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?