ADRIANA P
asked on
count hor 4n not repeat
data inout will be in
this area
then need by row not repat
this sample have one row but many rows will be
vertical can be repat not horizotal by row
c_hori_4n_not_repeat.xlsm
this area
then need by row not repat
this sample have one row but many rows will be
vertical can be repat not horizotal by row
c_hori_4n_not_repeat.xlsm
ASKER
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
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
Sorry but I don't know what that means, so please show me what the results for "000" would look like.
ASKER
000 should be 4
but 000 is not an good sample
but 000 is not an good sample
ASKER
405 should be better
how many times appear 05??
how many times appear 05??
There are only 4 cells that contain 405. Are you saying that you want it to show 5?
ASKER
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
that the reason any repeat by row should be eliminated
So how many should it show? Should it be 2?
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
29098636a.xlsm
ASKER
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
405 appear 2 times by row need just one
also the file
29098636a.xlsm
you post don't make sense to me
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
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
ASKER
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'.
ASKER
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
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
ASKER
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
C_H_to_count_w_not_repeat.
this file have the correction as needed
when you compare to Adriana.xlsm
you will see the differences
When I ask a question like this
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)
Are the following true?I'm looking for a simple 'yes' or 'no' answer.
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 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)
ASKER
Martin
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
Duplicates have to be delete by row not by column
then all we be add to be count for
YES !
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 !
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Martin
i see you did an great job
i see you did an great job
ASKER
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.
Además de decirme que hay un problema, debes describir cuál es el problema.
ASKER
Great Job
Best Expert
Best Expert
You sent me a message explaining that the "000" values were disappearing and the attached workbook corrects that problem.
29099776c.xlsm
29099776c.xlsm
29099776.xlsm