Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel: finding duplicates in a row.

Status
Not open for further replies.

davidrsutton

Programmer
Joined
Oct 6, 2004
Messages
94
Location
GB
Hi...

I have a worksheet with 4 columns. Columns B and C are text columns. In some rows, the values in columns B and C are identical and I want to be able to flag up these rows somehow.

I am using Excel 2000.

Many thanks in advance

Dave
 
You could do that using conditional formatting.

Go to Format / Conditional Formatting and select

"Cell Value is" - "Equal to" - (it's opposing cell)

Choose a suitable flagging format and you're there.
 
Alternatively, you could place a formula in your fifth column:

=IF(B1=C1,"a","r")

Change the font on the column to "Webdings" and you have a tick (check) or cross that can also be filtered using an autofilter on the column.
 
Cheers guys... I'll try this out and let you know!
 
If you want to try Dawber's suggestion of Conditional Formatting, I suggest selecting all the cells in columns B and C to be formatted, and using "Formula Is" with this formula:
=$B1=$C1 Change reference to row 1 to the top row in the selection

Brad
 
Dawber...

Your second suggestion did the trick.

Cheers!

Dave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top