View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heine Heine is offline
external usenet poster
 
Posts: 49
Default how to show if a table contains the same data

Hi everybody,

has anybody any idea of how to somehow highlight or show if I have the
same value twice or more times in a column?

For instance

1 Tom
2 Dick
3 Harry
4 Tom


Then I would like to somehow hightlight Tom. Problem is I have a lot
of data I want to search through.

Any thoughts?

Best regards
Heine