Assume the header in A is called Header1, in H2 put Header1 and in H2 put
#N/A, select Range A and B and as criteria use $H$1:$H$2, preferably copy to
another location and select unique records only

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"BorisS" wrote in message
...
I've always avoided advanced filtering, but it looks like it's one of the
few
ways for me to solve what I need.

I have to take a list of 11K entries, and find (UNIQUELY) the values in
column B, which are associated with the #N/A values in column A. In other
words, I need to basically show all N/A values, and then out of that
subset,
show the B values once each.

Can you tell me the basic setup? I know that it takes aligning criteria
above the search columns or something like that from the help, but as
advanced as I am with Excel, I've just never made it to advanced filters,
and
don't know how to use them.

Thx.
--
Boris