|Subject:||trouble with advanced filter|
|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.