Duplicate Entries

[Lewiy]

Is this perhaps the most common question subject in the forum? Perhaps we need a whole seperate board for duplicate entries discussion!!

 

[Oorang]

I haven't found too much faster then sorting by the field you want to check and then in the first datarow just typing =A2=A1 and copying down. (Assuming you were checking column a.) Anything true is a duplicate. The only catch is that if you intend to resort that data then you need to also copy/pastespecial values.

 

[erik.van.geit]

Is this perhaps the most common question subject in the forum? Perhaps we need a whole seperate board for duplicate entries discussion!!

it's so common that Oorang missed you didn't ask to solve the question itself
Hi, Aaron, we're in the Lounge here

 

[Oorang]

Oh fine

Edit: See look Eric, you killed the tread :wink: