One play which can deliver this ..
Assume source lists are in identically structured sheets: Master, Subset
in cols A and B, data from row1 down, with key col = col A (eg: unique ID
#s)
In another sheet, titled: Balance (say)
In A1:
=IF(Master!A1="","",IF(ISNUMBER(MATCH(Master!A1,Subset!A:A,0)),"",ROW()))
In B1:
=IF(ROW()>COUNT($A:$A),"",INDEX(Master!A:A,SMALL($A:$A,ROW())))
Copy B1 to C1 (as there 2 cols of source data. Just copy across by as many
cols). Then select A1:C1, copy down to cover the max extent of data expected
in Master. Hide away col A. Cols B to C will return the required "balance"
list ie lines in Master not in Subset, with all results neatly bunched at
the top.

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> Hello All,
>
[quoted text clipped - 9 lines]
>
> Maggie
Maggie - 31 Aug 2007 20:41 GMT
> One play which can deliver this ..
>
> Assume source lists are in identically structured sheets: Master, Subset
> in cols A and B, data from row1 down, with key col = col A (eg: unique ID
> #s)
Yes, "identically structured sheets"
> In another sheet, titled: Balance (say)
>
[quoted text clipped - 9 lines]
> "balance" list ie lines in Master not in Subset, with all results neatly
> bunched at the top.
Cool, will give it a go.
Thanks Max! :-)
Max - 01 Sep 2007 02:20 GMT
welcome. it should work fine.

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> Cool, will give it a go.
>
> Thanks Max! :-)