Excel - 'Where else does this appear' | AccountingWEB

Excel - 'Where else does this appear'

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?

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

Conditional formatting



Constantly Confused |
Constantly Confused's picture

A Macro

Steve Kesby |
Steve Kesby's picture

What I was thinking of ...


An extra column with the formula

ACDWebb |
ACDWebb's picture