How to highlight triple values
Solved
flexi2202
Posted messages
3640
Registration date
Status
Membre
Last intervention
-
flexi2202 Posted messages 3640 Registration date Status Membre Last intervention -
flexi2202 Posted messages 3640 Registration date Status Membre Last intervention -
Hello everyone
I have an Excel sheet with values in triples
in column A
how to highlight them
I tried with this formula under conditional formatting but it doesn't work
=COUNTIF($A$1:$A$10,A1)>2
Thanks for the help
I have an Excel sheet with values in triples
in column A
how to highlight them
I tried with this formula under conditional formatting but it doesn't work
=COUNTIF($A$1:$A$10,A1)>2
Thanks for the help
5 réponses
Hello
The MFC formula does not take line 11 into account, while the application range goes up to 59; and since you're looking for triples, might as well set it to =3
After selecting the range $A$1:$A$59
=COUNTIF($A$1:$A$59,A1)=3
https://www.cjoint.com/c/ICvlBaoF3zY
Best regards
The MFC formula does not take line 11 into account, while the application range goes up to 59; and since you're looking for triples, might as well set it to =3
After selecting the range $A$1:$A$59
=COUNTIF($A$1:$A$59,A1)=3
https://www.cjoint.com/c/ICvlBaoF3zY
Best regards
Hello,
Make a table with filters and sort the column with the triplets in ascending/descending order.
Then create a column that will count the number of identical cells in your column.
If you want me to provide the formula, please attach an anonymized excerpt of your table to your reply.
https://www.cjoint.com/
Best regards.
Make a table with filters and sort the column with the triplets in ascending/descending order.
Then create a column that will count the number of identical cells in your column.
If you want me to provide the formula, please attach an anonymized excerpt of your table to your reply.
https://www.cjoint.com/
Best regards.
Hello,
One reason why =COUNTIF($A$1:$A$10,A1)>2 does not work is that what you think is identical is not.
Spaces or char(160) might be included for example.
eric
--
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, it does happen!!!), remember to mark it as solved. Thank you.
One reason why =COUNTIF($A$1:$A$10,A1)>2 does not work is that what you think is identical is not.
Spaces or char(160) might be included for example.
eric
--
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, it does happen!!!), remember to mark it as solved. Thank you.
Hello Eriiic and Bryanlowen
thank you for the responses
actually, I don't want to count them, just highlight them in fluorescent yellow, for example, the 3 in triples
I am attaching a file, the sorting should be done in column A
knowing that I have thousands of lines in the actual file
https://www.cjoint.com/c/ICvk31LYIDO
can you clarify, Eric please
it's a formula I found on a forum
thank you for the responses
actually, I don't want to count them, just highlight them in fluorescent yellow, for example, the 3 in triples
I am attaching a file, the sorting should be done in column A
knowing that I have thousands of lines in the actual file
https://www.cjoint.com/c/ICvk31LYIDO
can you clarify, Eric please
it's a formula I found on a forum