As mentioned in my response, only col C needs to be minimized/hidden.
Col D is the results col.
Anyway, here's a link to a working sample for your easy reference:
http://www.savefile.com/files/1571748
Extract numbers in List B not in List A.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DRKENNE" wrote:
couldn't get that to work. Column A has data from A2:A913, Column B is
B2:B1657. There's about 700r ecords in Column B that aren't in A. I'm
hoping to find those that don't match A and move to new column.
I did select C and D down to 1657, but when I went to hide , C and D were
hidden. Did i miss something?