"Vikram Dhemare" wrote:
It is working as per the standards.
Also, could we extend the formula for qty also, that means for
matching the criteria of Invoice nos., Part Nos. as well as qty.

Think there was an error for the formula in F2 earlier. Just detected.
Sorry, my fault. The extension to bring in the qty as well is just a simple
copy across to the next col before filling down.

Here's the revised formula:

In sheet: I

(Array formulas in col E remain unchanged)

Put in F2:
=IF(ISERROR(SMALL($E:$E,ROW(A1))),"",INDEX(A:A,MAT CH(SMALL($E:$E,ROW(A1)),$E
:$E,0)))

Copy F2 to H2, then fill down until blanks appear,
signalling exhaustion of data extract

[since the discrepancy is around 2000 missing rows,
fill down to say, H2010 (say), to cover the expected extent]

Cols F to H would return all the invoice-part nos-qty in I
which are missing in II,
with all results neatly bunched at the top
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---