Today’s author is Charley Kyd, an Excel MVP, who describes how to use the SUMPRODUCT function to find the last sequential item in an Excel list. Charley has worked with spreadsheets in business since 1979, and has written books on spreadsheet use for McGraw-Hill and Microsoft Press. You can find more useful tips and posts from Charley and other Excel MVPs at his website, ExcelUser.com . Suppose you have a Sequential List of items, as in the second table here. And suppose you want to show the date
Read More...
Read the complete post at http://blogs.msdn.com/b/excel/archive/2010/08/04/use-sumproduct-to-find-the-last-item-in-an-excel-list.aspx
Posted
Aug 04 2010, 01:00 PM
by
Microsoft Excel 2010