Page 1 of Excel filtering help required

OK my turn to ask for help here :/ , I have 2 reports of data both formatted the same and what I need to work out are the differences between the two and just display those.

e.g Report 1 has for example A, B, D, F, G displayed and Report 2 has A,B,C,D,E,F,G,H and what I want to see as an output is just C,E,H. can this be done by filtering or are more advance formulae required?

Any ideas guys.

Cheers and Thanks in advance,
Baz.

This item was edited on Monday, 8th October 2007, 16:55

Advanced filtering is probably the correct tool.

I think I would use a vlookup though. Use vlookup to identfy the records, then the autofilter to select only the differences

I would place the formula alongside each record on each report and allow it to select where its matches are on the respective reports. Then filter the #N/As or the matches as you prefer.

I hope that makes sense. I`m sure some other peeps may have a better way though...

Neil.