Mar 21 2021 07:48 AM
I'm trying to create a dashboard that gives a weekly update on my business. I have managed to use the LOOKUP function to find the last/most recent value in my sales list. This works well as it updates on the dashboard when I add in the new value for the week just gone.
However, I also want another cell to show the second most recent value (i.e. the one above the value found first) to compare this week's value to last week's. How do I do that? Thanks
Mar 21 2021 08:05 AM
Let's say the sales data are on a sheet named sales in column K.
The last (bottommost) entry is returned by
=INDEX(Sales!K:K,MATCH(9.99999999999999E+307,Sales!K:K))
The next to last entry is returned by
=INDEX(Sales!K:K,MATCH(9.99999999999999E+307,Sales!K:K)-1)
Mar 21 2021 10:33 AM