retrieve info in excel 2000
 

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

retrieve info in excel 2000
 

Try DataFilterAutofilterCustom"contains".......... ."taxi"


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 09:46:05 -0700, droper
wrote:

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

retrieve info in excel 2000
 

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

retrieve info in excel 2000
 

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


"Gord Dibben" wrote:

Try DataFilterAutofilterCustom"contains".......... ."taxi"


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 09:46:05 -0700, droper
wrote:

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

retrieve info in excel 2000
 

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

retrieve info in excel 2000
 

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

retrieve info in excel 2000
 

Do not enter the quotes around "taxi"

Contains........taxi

Gord

On Thu, 12 Jul 2007 11:42:02 -0700, droper
wrote:

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


"Gord Dibben" wrote:

Try DataFilterAutofilterCustom"contains".......... ."taxi"


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 09:46:05 -0700, droper
wrote:

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

retrieve info in excel 2000
 

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

retrieve info in excel 2000
 

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.

--
Regards

Roger Govier


"droper" wrote in message
...
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

retrieve info in excel 2000
 

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
Regards...David Roper

Thanks for any help....David Roper


"Roger Govier" wrote:

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.

--
Regards

Roger Govier


"droper" wrote in message
...
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

retrieve info in excel 2000
 

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.
--
Regards

Roger Govier


"droper" wrote in message
...
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
Regards...David Roper

Thanks for any help....David Roper


"Roger Govier" wrote:

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.

--
Regards

Roger Govier


"droper" wrote in message
...
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