?
Solved

Show rows with duplicate cells

Posted on 2011-04-23
3
Medium Priority
?
217 Views
Last Modified: 2012-05-11
I want to be able to show the row numbers if a duplicate symbol exists.

Here is a screenshot including the formula I am trying to use in Google Docs.  Since this is a shared sheet, it unfortunately has to be done there.

http://screencast.com/t/AVIvpxMWwST
0
Comment
Question by:rtod2
  • 2
3 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35455117
Using vba macro or javascript?

Sid
0
 

Author Comment

by:rtod2
ID: 35455137
VBA.  The javascript guys I am going to have to wait on.
0
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 2000 total points
ID: 35455145
In fact you don't need VBA Macro. Try this formula in C3 and pull it down
 
=if(countif(B:B,B3)>1,"Duplicate","Unique")

I have updated the sheet.

Sid
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question