Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Using the example below, I need to match criteria in column a (Item #),
column B (store #) and where column D (Update Date) has the highest value, to return the data from column C (New Status). Item # Store # New Status Update Date 17829 4 A 8/9/2006 17829 4 D 4/29/2004 17829 4 N 3/15/2004 17829 4 I 1/26/2004 33467 33 A 8/9/2006 33467 33 D 4/29/2004 55000 53 D 4/29/2004 55000 53 N 3/15/2004 For instance, for store 4, item #17829, i would need new status A to be the resullt. For store 33, item # 33467, I would need status A to be the result. For store 53, item # 55000, I would need status D to be the result. Any and all help is greatly appreciated. |