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?
 - Counter strike 1.6 cheats list - Guide
 - Amd crossfire gpu list - Guide
 - How to change your best friends list on snapchat to 3 - Guide
 - Epic games free games list - Guide
 - Is snapchat blocked list in order - Instagram Forum
 
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