Multiple Filter

[pauluk]

I have a large excel file with numberous data entries. Each data that i
keyed in has a reference from AA to ZZ. The a date of completion

What i require to do is to look for certain refereces, ie

AA CC EE HH KK LL NN YY

Which have no completion date.

I usally do this by filtering for just on range ie AA then move ont
the next. This is now very time comsuming and i was wondering if anyon
had any suggestions.

Regards
Pau

 

[Mark Graesser]

Hi paul
The easiest way to do this is probablty by using a helper column and a table. Enter the following formula in a blank column and copy down

=IF(ISERROR(MATCH(A2,$H$2:$H$8,0)),0,1

A2 is the cell being tested, and $H$2:$H$8 is the range of your table. Thos will produce o when the item isn't in the table, and 1 when it is. Now you can filter or sort on this column

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- pauluk > wrote: ----

I have a large excel file with numberous data entries. Each data that i
keyed in has a reference from AA to ZZ. The a date of completio

What i require to do is to look for certain refereces, i

AA CC EE HH KK LL NN Y

Which have no completion date

I usally do this by filtering for just on range ie AA then move ont
the next. This is now very time comsuming and i was wondering if anyon
had any suggestions

Regard
Pau