Duplicate Values

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

I have a spreadsheet that has 3000 entries and I have a coloum called
SBS_No only problem is that I think I have duplicate entries as the
SBS_No is unique. Is there anyway that I could get excel to point out
any duplicate values. Like returning value false if it is a duplicate
value.

Fiona
 
Fie,

In another column, use a formula like this

=COUNTIF(B:B,B2)=1

This assume SBS_No is column B, and row 2 is your first row. Then copy down to match your data set,
and filter on that column to show FALSE values - those will be your duplicates.

HTH,
Bernie
MS Excel MVP
 
Back
Top