• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 73
  • Last Modified:

count digit pair mid 4n

need count coulmn EO

show in coulmn FF FG and put together
  first 2  , then first 3

a33.PNGn4_9876543.xlsm
0
ADRIANA P
Asked:
ADRIANA P
  • 4
  • 3
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Try sending an example of what the result would look like.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Saqib Husain, Syed   Thanks for the reponse

need count each digit  then show as here
a34.PNGa34.PNG
0
 
Saqib Husain, SyedEngineerCommented:
Does the order of the numbers matter?
1
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Saqib Husain, Syed

 the oder should be as appear
0
 
Saqib Husain, SyedEngineerCommented:
The FF numbers you should insert manually.

For FG enter this formula in FG1526

=2*COUNTA($EO$1534:$EO$1537)-SUMPRODUCT(LEN(SUBSTITUTE($EO$1534:$EO$1537,FF1526,"")))
1
 
Martin LissOlder than dirtCommented:
I wasn't sure which days in EO you wanted to include, but your picture points out data from the last half so that's what I chose.
29083031.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job Martin Working as needed!
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Saqib Husain, Syed

thanks for the  Response

im not an computer literracy
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now