I have a formula that I use in a sales spreadsheet to find the last time a customer made a purchase-
=LOOKUP(2,1/(C1:C25=D50),F1:F25)
Where D50 is the customer number, column C contains customer numbers and F contains the sales amounts. Column C does contain blanks.
It works perfectly.
I now have a need to find the 2nd to last sales amount for customers. Searching online gives me formulas to find the 2nd to last item but I am having trouble converting that to finding second to last match. Like this array formula:
=INDEX(B:B,LARGE(IF(B:B<>"",ROW(B:B)),2))
Anyone know how I can accomplish this?
Mark
Bookmarks