Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

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


User generated image
here the file to
29082163_333N.xlsm
Avatar of Arana (G.P.)
Arana (G.P.)

I dont understand, can you be more clear? GY , GV and GY are empty , so i cannot figure out what you need.
Avatar of ADRIANA P

ASKER

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
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]?
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 ]
[ fanpages ]

thanks for the fast reponse

the file is here  inthis question
...but clarification about your actual question in this thread is not.
[ 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
[ 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
[ 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)
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Martin

That's not what your picture shows.

ok i understand know
but i try to best explain as better  as i can
Martin Great Job

Working as needed !!