Avatar of 633535
633535

asked on 

Compare and identify rows with unique values

Hello - Sample sheet attached.  Using Excel 2007.

I need to identify which rows are unique, and alike.  I *think* it would be a formula that compares rows in range B2:F:6, finds which ones are the same, and indicates which ones are the same (somehow?).  E.g. if the contents of each cell in range B2:F2 matches the contents of each cell in range B6:F6, and the alike rows are indicated with (?) a number unique to them in column G??

Thanks in advance.
Sample-unique-row-IDs.xlsx
Microsoft Excel

Avatar of undefined
Last Comment
633535

8/22/2022 - Mon