Excel - 'Where else does this appear'

Posted by Constantly Confused PM | on Tue, 10/04/2012 - 11:36 682 5 comments | report

Say I have a timesheet. I put in 'Mr A Bloggs' and wonder, 'What other entries were made for this client?'.

I know I can filter, but assume that is impractical for my purpose. I could also highlight duplicates, but that would highlight every duplicate (so I believe). I could even just search, but that's a little fiddly.

Any way I can highlight duplicates in a row based on one cell? So consider B100 and highlight entries in B matching it?

Comments

There are 5 comments. Login or register to view them.

Conditional formatting

BKD | Tue, 10/04/2012 - 12:26

Thanks

Constantly Confused | Tue, 10/04/2012 - 12:34

A Macro

Steve Kesby | Tue, 10/04/2012 - 14:23

What I was thinking of ...

BKD | Tue, 10/04/2012 - 14:42

An extra column with the formula

ACDWebb | Tue, 10/04/2012 - 14:47