Hello everybody,

While checking excel newsgroups, i've found that it's quite easy to compare
two ranges that have the same size (say A1:A10 against B1:B10).

In my particular case however, it would be much better if I could compare
ranges that are different in size (let's say A1:C15 against D1:E7), possibly
containing some blank cells as well. From these two ranges, I would like to
extract all the (non-blank) cells that appear in A1:C15 but not in D1:E7.

Do you have any idea what is the best way to do this?
Are there any useful formulas that could cover my case or am I obliged to
pass through VBA?

Thanks a lot for any hints!
Cheers,

Mark