Filtering a worksheet if same value found in differnet columns

[be_insane]

Ok a little confusing to explain.

I have a spreadsheet set up, where differnet columns may contain the
same values for example:


Col1 Col2 Col3

Item1 A
Item2 H
Item3 B A
Item4 G H
Item5 A


What i would like to do is be able to filter on conditions if a value
is found in either Col2 or Col3, for example "A" which would return
item1, item3 and item5.

I've not played to much with filters but would love to get this
working. The tricky part is that the condition will change, eg today we
need all enteries where "H" applies... tommorow "A"

Should i give up in excel and go to Access?!?!

Any help would be brill.
B

 

[Earl Kiosterud]

B,

Are you looking for a specific given value, like A, or do you want to
identify ANY records with matching values (A and H in this case). If the
latter, how is it to indicate which matches which-- how should it look?