count hor 4n not repeat

data inout will be in

this area

56789.PNG

then need by row not repat

eeeeeeeeeeeeeeeeeeee.PNG

this sample have one row but many rows will be

vertical can be repat not horizotal by row

eeeeeeeeeeeeeeeeeeee.PNGc_hori_4n_not_repeat.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
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.

Martin LissOlder than dirtCommented:
It looks to me like rather that counting how many times "000" (for example) occurs in the data, you want the count of how many rows contain "000". The attached workbook does that.
29099776.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

is an great idea

but  the situation
still  need to know how many times the numbers appear

when is in the same row the repeat just over count the same number by row ( horizontal)
but not vertically
0
Martin LissOlder than dirtCommented:
Sorry but I don't know what that means, so please show me what the results for "000" would look like.
0
The Ultimate Tool Kit for Technolgy Solution Provi

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 for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
000  should be 4

but 000 is not an good sample
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
405  should be better

how many times appear 05??
0
Martin LissOlder than dirtCommented:
There are only 4 cells that contain 405. Are you saying that you want it to show 5?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
the situation  here is  405   is show more than one by row  05 will be overcounted

that the reason any repeat by row should be eliminated
0
Martin LissOlder than dirtCommented:
So how many should it show? Should it be 2?
0
Martin LissOlder than dirtCommented:
I may have not uploaded my most current workbook so take a look at this one. It shows 000 = 4 and 405 = 2. If 405 isn't correct then you need to tell me what it should be.
29098636a.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
can the repeat numbers by row be eliminated

405 appear 2 times by row  need just one


also the  file
29098636a.xlsm

you post  don't make sense to me
0
Martin LissOlder than dirtCommented:
In this workbook please put the correct counts in the green cells and then attach it so I can see the results.

En este libro de trabajo, coloque los recuentos correctos en las celdas verdes y luego adjúntelo para que pueda ver los resultados.
Adriana.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

here how shild be without the repeat by row
C_H_to_count_w_not_repeat.xlsm
0
Martin LissOlder than dirtCommented:
Are the following true?
  1. The counts in column 'AE' in my A'driana' workbook are correct.
  2. You want me to delete the duplicate values in columns 'A' to 'AB'.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Are the following true?
The counts in column 'AE' in my A'driana' workbook are correct.

i repeat if the number repeat by row  is over counting the answer needed

You want me to delete the duplicate values in columns 'A' to 'AB'.

again best expert

i say not repat by row

because is over counting

the total count


Sorry but i repeat the same again and again

need to eliminate the duplicate by row not by column



then after the duplicates are eliminate by row
they will be add  to be count  best expert
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
also i upload the file
C_H_to_count_w_not_repeat.xlsm  

this file have the correction as needed

when you compare to Adriana.xlsm
you will see the differences
0
Martin LissOlder than dirtCommented:
When I ask a question like this
Are the following true?
The counts in column 'AE' in my A'driana' workbook are correct.
You want me to delete the duplicate values in columns 'A' to 'AB'.
I'm looking for a simple 'yes' or 'no' answer.

I assume that the answer to the first question is 'no'.

Let me ask the second question in a different way. For each row, do you want me to replace duplicate numbers with spaces? For example, should I change cell R4 from 059 to blank? ('Yes' or 'no' please)
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Are the following true? The counts in column 'AE' in my A'driana' workbook are correct.

in Adriana.xlsm  the count you show are correct  for AE column

but thst the only one correct  

the PAIR count  (AG,AH) is not  and the others are  not too (range , digit) and have to be count too

that  why i recommend  as i  say

to make easy


You want me to delete the duplicate values in columns 'A' to 'AB'

Duplicates have to be delete by row not by column

then all we be add to be count for



For each row, do you want me to replace duplicate numbers with spaces? For example, should I change cell R4 from 059 to blank? ('Yes' or 'no' please)

YES !
0
Martin LissOlder than dirtCommented:
In this workbook I first deleted the duplicate values by row and then did the TRI, PAIR, RANGE and DIGIT counts. The results for TRI match yours but the rest don't.
29099776b.xlsm
0

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.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

i see you did an great job
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
aq2.PNG
can the 000 issue by fixed

if you see C_H_to_count_w_not_repeat.xlsm
then  29099776b.xlsm

 that is the difference
0
Martin LissOlder than dirtCommented:
In addition to telling me that there is an issue you need to describe what the issue is.

Además de decirme que hay un problema, debes describir cuál es el problema.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job
Best Expert
0
Martin LissOlder than dirtCommented:
You sent me a message explaining that the "000"  values were disappearing and the attached workbook corrects that problem.
29099776c.xlsm
1
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
VBA

From novice to tech pro — start learning today.