Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
how to put data in the column A to the next row of the column B | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
In a column with no data, only color filling, how can I filter fo. | Excel Discussion (Misc queries) |