| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Possible index/match problem?
II have a list that contains col. A with dates in it. Cols. B, C, D, E,
and so on contains either a number or "Free" or "Vac". I need to extract the dates that have Vac. beside them and have them listed on another sheet, per the following example. Is index/match the way to go about this? Thanks for any help you can give. Date Tom Dick Harry 1/2 8 8 Vac. 1/3 8 Vac. 8 1/4 Vac. 8 Free 1/5 Vac. Vac. 8 Summary on next sheet: Tom Dick Harry 1/4 1/3 1/2 1/5 1/5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
