| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching for a number in a list
Hi - I'm trying to do the following:
In Cell B1, I have the value "Smith, Joe" In cell a4, I have a total number of hours for Joe Smith: 40. Depending on the detail hours reported, the total hours may be in a different line. For example, if Joe had 6 line items of detail, the total would be in line a6. So, I have to first find Joe Smith in the spreadsheet, then find the total line. Any ideas? Paul Peterson Velox Consulting. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching A List | Excel Worksheet Functions | |||
| searching for a word(s) within a list | Excel Discussion (Misc queries) | |||
| Searching for a contact without going through the whole list. | Excel Worksheet Functions | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| searching within list | Excel Discussion (Misc queries) | |||
Threaded Mode
