| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
search in excel 2000 (9.0.2720)
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
search in excel 2000 (9.0.2720)
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 "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" 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
| Excel 2000 - How to create an auto search | Excel Discussion (Misc queries) | |||
Hybrid Mode
