To filter for the first record for each value in column B, where the
value in column A is #N/A --

In cell A1, enter the heading from cell A4
In cell A2, enter #N/A
Leave cell B2 blank
In cell B2, enter:
=SUMPRODUCT(--($B$4:$B5=B5),--(ISNA($A$4:$A5)))=1

Run the Advanced Filter, using cells A1:B2 as the criteria range.

BorisS wrote:
I'll try to clarify what I'd written.

I actually have 10 columns. First row has the headers (call them HeaderA1,
HeaderB1, etc.). Rows 2 and 3 are blank, waiting for the advanced filter
criteria (if I understand correctly how it's supposed to be set up). Row 4
has the headers again (HeaderA4, HeaderB4). All 11K records are below. I
need to have a subset list where I search only the rows that have #N/A values
in the A column, and then return unique records of the resulting B column
values. And I need to have the entire line of 10 column shown in the subset.

So with that prep, can you tell me how I'd set up the advanced filter
dialogue?

Thx.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html