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
I would like a to list each row that has a matching set of numbers with another row in a spreadsheet.

For example: Rows (1) and (4) have the numbers 4,6,7 and 9.
And rows (2) and (3) have the numbers 5,2,1 and 3.

__ A B C D
(1) 4 6 7 9
(2) 5 2 1 3
(3) 5 2 1 3
(4) 4 6 7 9
(5) 2 5 9 7


I'd like to be able to highlight or list every row that has the same group of numbers as any other row in the spreadsheet.

Something like - if the numbers in rows 1:5 match the numbers in any other row, then highlight or list the rows.

Thanks in advance :-)

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
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
0