One way is to concatenate the values in Column G like this
=A1&B1&C1&D1&E1&F1

then use this in Col H
=Countif(G1:$G100,G1)
(change 100 to the last row number) and copy down.

Cells with value 1 will show duplicate cells.

"Michael Joseph Cosgriff" wrote:

I have used a RANDOM NUMBERS web page to make a collection of 6 columns from
A1 to F50. Now I want to scan them to see if I have repeated any rows. Can
someone help with a formula

Mike Cosgriff