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


q1q1.PNG
here the file to
29082163_333N.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
then put together pair and tri in column GY
That's not what your picture shows.

Try this anyhow.
29083676.xlsm
1
 
aranaCommented:
I dont understand, can you be more clear? GY , GV and GY are empty , so i cannot figure out what you need.
1
 
ADRIANA PACCOUNTING 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
[ fanpages ]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
 
[ fanpages ]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
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
[ fanpages ]

thanks for the fast reponse

the file is here  inthis question
0
 
[ fanpages ]IT Services ConsultantCommented:
...but clarification about your actual question in this thread is not.
1
 
ADRIANA PACCOUNTING 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
 
ADRIANA PACCOUNTING 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
 
ADRIANA PACCOUNTING 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
 
ADRIANA PACCOUNTING 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
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin Great Job

Working as needed !!
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.

All Courses

From novice to tech pro — start learning today.