trouble with advanced filter

Giganews Newsgroups
Subject: trouble with advanced filter
Posted by:  BorisS
Date: Sat, 27 May 2006

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

Replies