| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieving data based on most recent date
I have two sheets. On one sheet I have products and inventory taken on
different days: A1 B1 C1 05/08/07 Product1 1300 05/08/07 Product2 560 30/08/07 Product1 685 30/08/07 Product3 1513 05/09/07 Product3 669 05/09/07 Product1 1754 05/09/07 Product2 555 On sheet two I want to retrieve the most recent inventory for each product as well as the corresponding date. A1 B1 C1 Product1 1754 05/09/07 Product2 555 05/09/07 Product3 669 05/09/07 Does anyone know what formulas I would use to do this? I'm using Excel 2000. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Retrieving data based on most recent date
Sheet 2:
C2: =SUMPRODUCT(--(MAX((Sheet1!$B$2:$B$8=A2),Sheet1!$A$2:$A$8))) copy down B2: =SUMPRODUCT(--(Sheet1!$B$2:$B$8=A2),--(Sheet1!$A$2:$A$8=C2),Sheet1!$C$2:$C$8) copy down "cdoch" wrote: I have two sheets. On one sheet I have products and inventory taken on different days: A1 B1 C1 05/08/07 Product1 1300 05/08/07 Product2 560 30/08/07 Product1 685 30/08/07 Product3 1513 05/09/07 Product3 669 05/09/07 Product1 1754 05/09/07 Product2 555 On sheet two I want to retrieve the most recent inventory for each product as well as the corresponding date. A1 B1 C1 Product1 1754 05/09/07 Product2 555 05/09/07 Product3 669 05/09/07 Does anyone know what formulas I would use to do this? I'm using Excel 2000. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieving data based on more than 1 criteria | Excel Worksheet Functions | |||
| Sumproduct based which also weights data based on date | Excel Worksheet Functions | |||
| How to find the most recent date in a column based on other column | Excel Worksheet Functions | |||
| Retrieving value from list based on dynamic condition | Excel Discussion (Misc queries) | |||
| Compare multiple dates, can enumerate cell based on most recent date | Excel Worksheet Functions | |||
Linear Mode
