Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
look up last date ordered
I have a spread sheet like this
date item descr qty 9/1/06 56 desc 23 9/5/06 67 desc 100 9/8/06 56 desc 16 9/16/06 10 desc 50 9/5/06 56 desc 100 on another worksheet i have a lsit of item numbers and descriptions i want to create a column showling last dateordered of item #56, is there a simple way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
look up last date ordered
Try something like this:
With your data table on Sheet2 in A1:D6 (column headings in Row_1) On sheet1 cell A1 This formula returns the latest order date for Item 56 A1: =SUMPRODUCT(MAX((Sheet2!B2:B6=56)*Sheet2!A2:A6)) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "LEOPARDSHIDEAWAY" wrote: I have a spread sheet like this date item descr qty 9/1/06 56 desc 23 9/5/06 67 desc 100 9/8/06 56 desc 16 9/16/06 10 desc 50 9/5/06 56 desc 100 on another worksheet i have a lsit of item numbers and descriptions i want to create a column showling last dateordered of item #56, is there a simple way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF and Date Functions | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions |