Finding duplicate data

Eric Stoakes · Dec 8, 2004

Hello,
I was wondering is there an easy way to find duplicate data on a
worksheet? All data is in 200 rows and 5 columns.

Thanks
Eric

Frank Kabel · Dec 8, 2004

Eric Stoakes · Dec 9, 2004

It works fine with 2 columns and if I simplify the data. The data contains 7
alpha and numerical in random order.

Frank Kabel · Dec 9, 2004

Hi
could you post some example data