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? |
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? |
All times are GMT +1. The time now is 10:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com