View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Secret Squirrel Secret Squirrel is offline
external usenet poster
 
Posts: 172
Default Finding Duplicate Rows

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?