search in excel 2000 (9.0.2720)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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" in column B1.
Then"Best travel company" in A2, then "Transport, travel, taxis" 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
 
You can return the entire "rows" if any cell in a specific column contains
the word "taxi" by just using the Autofilter, Custom, and choosing the
"contains" selection.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top