Can excel Flag repeat entries?

C

Capytanred

This is my first post. I have a bunch of cases that are numbered that
I've dumped into a spreadsheet. I need to find out how many duplicates
there are, for instance a case might be labeled REF242 and there will be
2 of those ect. I need to know which one's are duplicates so I can
subtract the dollar amount associated with the repeats. Does anyone
know how to do this in excel?
Thanks,
KB
 
B

Bob Umlas

you can identify the duplicates by a formula. Suppose your list is in
A1:A100. In B1 enter =IF(COUNTIF(A$1:A$100,A1)>1,"Dup","") and fill down to
B100.
 
Top