Compare two ranges, extract exceptions

[mkvassh]

I want to compare two ranges (Rng1 and Rng2) and end up with a third range with values in Rng1 that doesn't exist in Rng2. There are several ways to do this, but I want to end up with a third range with no empty lines.

I have attached an example. I can use a VBA macro or function. Both are OK.

[MickG]

Hi, Try this:-

Please Login or Register  to view this content.

Regards Mick

[mkvassh]

Thank you :-)