my dropdown only shows ..all..top 10..custom..blanks..non blanks does not
show "True"
--
Thanks for any help....David Roper


"Roger Govier" wrote:

Hi

If you mark your header row and choose DatafilterAutofilter a series
of dropdown arrows appears in the cells.
Click the dropdown on column C and select TRUE.
This hides all the rows not showing TRUE, so you have filtered out only
those that meet your condition.

--
Regards

Roger Govier


"droper" wrote in message
...
Thanks but I am stuck where you say "filter on column c for true".
I don't know how you do that
--
....David Roper


"Roger Govier" wrote:

Hi

Assuming you have a header in row, and that it is only columns A and
B
then I would create a test in column C.
In C1, enter the word you want to find e.g. taxi
in C2 enter
=ISNUMBER(MATCH($C$1,A2:B2,0))
and copy down for the extent of your data.
Apply DataFilterAutofilter
Widen column C, so there is plenty of room to type in the word you
are
searching for, without the dropdown arrow getting in your way.
Filter on column C for TRUE
Filter on CShow All to return to your full list.
Type any other word in C1, then Filter for TRUE again

--
Regards

Roger Govier


"droper" wrote in message
...
We have a filing system which has the file name in col A, and
keywords
in col
B. For example "Aa taxis" in A1, then "transport, travel, cars
etc."
in
column B1.
Then"Best travel company" in A2, then "Transport, travel, taxis
etc."
in B2.
Then "Bonapart Restaurant" in A3, then "entertaining, eating" in
B3.
I want to key in "Taxi" then have excel retrieve A1,A2,B1 & B2 &
any
other
cells which contain the word "Taxi".
Please bear in mind that I am not very technical, so for answers to
be
of
any help they need to be "Idiot proof".
(Did I just call myself an idiot?)
Thanks for any help....David Roper

--
Thanks for any help....David Roper