compare lists

  • Thread starter Thread starter Jim S.
  • Start date Start date
The answer is yes.

Suppose you have a list in column A and another list in column C.
Highlight column A, so that A1 is the active cell and click on Format
| Conditional Formatting. Choose Formula Is rather than Cell Value Is
in the first box and enter this formula in the next box:

=NOT(ISNUMBER(MATCH(A1,C:C,0)))

Then click the Format button, then the Patterns tab (for background
colour) and choose your colour. OK your way out.

Then highlight column C and repeat with this formula:

=NOT(ISNUMBER(MATCH(C1,A:A,0)))

The highlighted items are not in both lists.

Hope this helps.

Pete
 
Hello,

Thanks Pete. It is wonderful. It will be of help to me in many cases.

Regards,

Jaleel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare multiple cells and highlight differences 5
Compare data in two different workbooks 1
Functions 1
Function 7
Compare lists and highlight matches 2
Compare lists and highlight matches 3
What formula should I use? 1
Comparing two Excel data ranges for chnages... 2

Back
Top