Excel: finding duplicates in a row.

[davidrsutton]

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

 

[Dawber]

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.

 

[Dawber]

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.

 

[davidrsutton]

Cheers guys... I'll try this out and let you know!

 

[byundt]

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

 

[davidrsutton]

Dawber...

Your second suggestion did the trick.

Cheers!

Dave