I have list with 5 columns. I am trying to identify duplicates in rows and
columns can this be done in Excel? or How should I go about this? For
instance
col contains id and need to check to see if there are dups. For the first
col(ids) I am using this function =IF(COUNT(B$2:B2,B2)1,"Duplicate","No
Dup") this works fine. However, going across the next three rows contain the
same information but col 5 in most instances contain the same information for
the rows but there are some instances where the value may be different. I
want to be able to flag/identify these exceptions. Can there be something
added to the function above to include up to col 5 for "Duplicates". Can
someone please help me with this function or what is a better what to
identify "duplicates" down and across this worksheet??? Thank you in advance
for any help you can provide.