Filter over 3 Columns using 1 drop-down box

[Gavin Harrison]

Hi All.

I've trying to code the following but not yet managed it!

I'm looking to filter a data range let's say A5:C200. The criteria will be the value of a drop-down box in D1 selected by the user. The value will only be contained in one of the columns.

As always, any help appreciated.

Thanks

 

[Toadstool]

Add a worker column and filter on that.
=IF(ISNA(MATCH($D$1,A5:C5,0)),"",COUNTIF(A5:C5,$D$1))
then filter on the worker column selecting only "1" entries so it doesn't show when the value is in more than 1 column.

[/URL][/IMG]