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