Finding Duplicate Rows

  • Thread starter Secret Squirrel
  • Start date
S

Secret Squirrel

I have a worksheet with a detail tab and a summary tab. In column A on my
summary tab I have a list of values. What I want to do is look these values
up on my detail tab and see if they exist more than once. If they do I just
want to return a value of "1" in column B on my summary tab. Some of these
values are a combination of text and numbers. How would I write this formula?
 
R

Ragdyer

Say the values in "detail" are in Column A, from A1 to A100.

If you have your unique list of values in "summary", also in Column A,
Enter this in B1 of "summary", and copy down as needed:

=--(COUNTIF(detail!$A$1:$A$100,A1)>1)

This will return a "1" if there are duplicates, and a 0 if there are 1 or no
matches.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


Secret Squirrel said:
I have a worksheet with a detail tab and a summary tab. In column A on my
summary tab I have a list of values. What I want to do is look these values
up on my detail tab and see if they exist more than once. If they do I just
want to return a value of "1" in column B on my summary tab. Some of these
values are a combination of text and numbers. How would I write this
Click to expand...
formula?
 
Top