How can I list, matchings 'sets' of numbers?
Closed
Stumped
-
Apr 3, 2010 at 09:38 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 4, 2010 at 11:43 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 4, 2010 at 11:43 AM
Related:
- How can I list, matchings 'sets' of numbers?
- How to change your best friends list on snapchat to 3 - Guide
- My contacts list names - Guide
- Counter strike 1.6 cheats list - Guide
- Whatsapp country code list - Guide
- Amd crossfire compatibility list - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 4, 2010 at 11:43 AM
Apr 4, 2010 at 11:43 AM
Is it possible to have a temp/working column in that sheet ?
If that can be done then most easy way would be
Let say in column F we can have temp formula
in F1 you can write
=A1 & "|" & B1 & "|" & C1 & "|" & D1
copy this formula down to last row of data
Then select all the cells and go to conditional formatting and apply this formula
=COUNTIF($F:$F, $F1)>1
click on format and choose the color
If that can be done then most easy way would be
Let say in column F we can have temp formula
in F1 you can write
=A1 & "|" & B1 & "|" & C1 & "|" & D1
copy this formula down to last row of data
Then select all the cells and go to conditional formatting and apply this formula
=COUNTIF($F:$F, $F1)>1
click on format and choose the color