| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index, Vlookup, Offset
I have the following raw data setup:
Invoice# Date Description Amount 2007-1 4/1/07 Signage 250.00 2007-1 4/1/07 Mugs 115.00 2007-2 4/2/07 Signage 275.00 In a summary sheet: I would like to pull the first "Date" for "Invoice#" 2007-1 on line 1. If Invoice# 2007-1 has a second record, I would like to then pull the second "Date" for "Invoice#" 2007-1 on line 2. Thank you in advance for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index match offset? | Excel Worksheet Functions | |||
| Want to offset found value using Index | Excel Worksheet Functions | |||
| Lookup, Index or Offset | Excel Discussion (Misc queries) | |||
| Index, Match, Offset? Not sure which to use | Excel Worksheet Functions | |||
| Which to use - if, vlookup, match, index, offset, vba? | Excel Discussion (Misc queries) | |||
Threaded Mode
