retrieve info in excel 2000

  • 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 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
 
Try Data>Filter>Autofilter>Custom>"contains"..........."taxi"


Gord Dibben MS Excel MVP
 
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 Data>Filter>Autofilter
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 C>Show All to return to your full list.
Type any other word in C1, then Filter for TRUE again
 
Thanks but I do the steps you list and am left with an empty cell. I think
there must be a step missing
....David Roper
 
Thanks but I am stuck where you say "filter on column c for true".
I don't know how you do that
 
Hi

If you mark your header row and choose Data>filter>Autofilter 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.
 
Hi David

If you did, successfully, it should show a column of TRUE and FALSE
entries.
Do you have a blank row below the header row? If so, delete it.
 
Hi Roger
Sorry but I am still only being offerred
"..all..top 10..custom..blanks..non blanks" does not
show "True".
When you say "mark your header row" you do mean "Highlight your header row"
don't you?
Are we using diferent versions of excel? I am on Excel 2,000.
How about if you emailed a small working version to me, in which I could
then fill in our data? Then I could post you a cheque for say $25 or £15 for
your trouble.
My email address is (e-mail address removed)
Regards...David Roper

Thanks for any help....David Roper
 
Hi David

Formula amended in C2 to
=IF(A2="","",ISNUMBER(SEARCH($C$1,A2&B2)))

Small sample data sheet with 8 rows of data showing TRUE FALSE for
values entered in C1 mailed direct to you.
Click the dropdown on column C to just show the TRUE values.

For this tiny task, there is no charge, but thanks for the offer.
 
Back
Top