| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I retrieve info from a file/wksht I copied over in Excel? | Excel Discussion (Misc queries) | |||
| How do I retrieve info. from one worksheet for another in Excel? | Excel Worksheet Functions | |||
| Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
| Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
| Can I make one spreadsheet retrieve info from previous spreadshee. | Excel Discussion (Misc queries) | |||
Linear Mode
