# count each digit in 3nMP

need count each digit

in the  EY Column  (can shrink or grown as needed)

then show result in GV  GW

then put together pair and tri in column GY

here the file to
29082163_333N.xlsm
ACCOUNTING ASSISTANTAsked:
###### Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
I dont understand, can you be more clear? GY , GV and GY are empty , so i cannot figure out what you need.
1
ACCOUNTING ASSISTANTAuthor Commented:
arana  thanks for the fast response

need count each digit

in the  EY Column  (can shrink or grown an needed)

then show result in GV  GW

then put together pair and tri in column GY
0
IT Services ConsultantCommented:
Repeating what you said originally isn't going to help!

Please try to re-word your question/request.

Thanks.

I think you may be asking to calculate the number of digits of all the values in the range [EY1513:EY1525] & distribute the quantities of digits in the range [GV1514:GV1523] (row 1514 being all the count of numbers in column [EY] that have a single digit, 1515 the quantity that have two digits, 1516; those with three,... up to row 1523 that is the quantity of numeric values that have ten digits).

However,...

Are "01" & "09" one digit, or two digits?
Are you expecting the same outcome in every other block of 13 rows throughout the rest of column [EY]?
1
IT Services ConsultantCommented:
Can we use the workbook file attached to the question thread below as a starting point, or has it changed recently?

[ https://www.experts-exchange.com/questions/29083653/Hide-unhide-3n-tpw.html ]
1
ACCOUNTING ASSISTANTAuthor Commented:
[ fanpages ]

thanks for the fast reponse

the file is here  inthis question
0
IT Services ConsultantCommented:
...but clarification about your actual question in this thread is not.
1
ACCOUNTING ASSISTANTAuthor Commented:
[ fanpages ]

if you have any question
you can ask

as i understand by now
you ask
Can we use the workbook file attached to the question thread below as a starting point, or has it changed recently?

i answer the question

any other question
have to be ask for
0
ACCOUNTING ASSISTANTAuthor Commented:
[ fanpages ]

in repose to ID: 42466878
question!

like arana ask

my best  explanation is read carefully

then

1-need count each digit
in the  EY Column  (can shrink or grown an needed)

2-then show result in GV  GW

then put together pair and tri in column GY

i show up where  numbers comes from and  where goes
0
ACCOUNTING ASSISTANTAuthor Commented:
[ fanpages ]  thanks for the ask

Are "01" & "09" one digit, or two digits?

they are 2 digit
example  01  is 0 and 1

Are you expecting the same outcome in every other block of 13 rows throughout the rest of column [EY]?

well like i say
data  in the  EY Column  (can shrink or grown as needed)
0
Older than dirtCommented:
then put together pair and tri in column GY
That's not what your picture shows.

Try this anyhow.
29083676.xlsm
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

ACCOUNTING ASSISTANTAuthor Commented:
Martin

That's not what your picture shows.

ok i understand know
but i try to best explain as better  as i can
0
ACCOUNTING ASSISTANTAuthor Commented:
Martin Great Job

Working as needed !!
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.