What is the easiest formula to use when looking for duplicates in a column? Please and thank you.
E Eán Mar 17, 2009 #1 What is the easiest formula to use when looking for duplicates in a column? Please and thank you.
S Shane Devenshire Mar 17, 2009 #2 Hi, Something like =COUNTIF(A$1:A$100,A1) Copy this down, anytime the value is greater than 1 you have a duplicate. Apply an autofilter to this formula column for greater than 1.
Hi, Something like =COUNTIF(A$1:A$100,A1) Copy this down, anytime the value is greater than 1 you have a duplicate. Apply an autofilter to this formula column for greater than 1.
