Use SUMPRODUCT to find the last item in an Excel list  image
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,
Suppose you have a Sequential List of items, as in the second
table here. And suppose you want to show the date of the first
and last entry in the list. How would you do it?  This question
isn’t limited to dates, by the way. The Sequential List could
display numbers or text instead. How would you write the
formulas used in the range B4:C6 to return the dates of the
first and last items?  Many Excel users could quickly write a
formula that returns the first date for each item in the list.
They would use an INDEX-MATCH formula like this for the cell
shown:  B4:  =INDEX(Date,MATCH(A