In excel, how do I omit duplacates when sorting new info.

B

Blaine Fray

I am using Microsoft Excel 2003. I would like to know when imputtiing new
data into a spreadsheet that already exsits, how do I omit duplacates?
 
D

d

If your data is in range, say A1:A10, I would, in cell B1, type
"=COUNTIF($A$1:$A$10;A1)". And copy the formula down in B1:B10. This way, if
you read anything higher than 1 in the B cell, it means the value already
exists in the range.
 
Top