View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
mmaan mmaan is offline
external usenet poster
 
Posts: 3
Default Filter data from one collum by looking up from another column

Hi,
I am stuck on the following problem:

I want to exclude names (or give them another color) from 1 column if they
are also in another column.

To illustrate this, the result from the following data:
A B
1 John Peter
2 Sue Floyd
3 Peter Dan
4 Mike Chris

would have to be:
John
Sue
Mike

Or in this case I could use a conditional formatting to paint A3 red.

How do I do this?