Hi,
I'm looking for a formula that searches for the last [x] number of values in another particular data range. I've attached a spreadsheet to help me explain. The sheet titled 'Data' contains all the data, the sheet titled 'Last 20' contains the sheet where I want to develop the formula.
In 'Last 20', I want to search for the person's name and find the last/final 20 values in the data range contained in 'Data'. So basically count back from the end, all the way to the beginning and find the last 20 numbers displayed. I want this to include for blanks and for a dash ("-"). Where it displays 'Date 1', 'Date 2', etc. I want to display the date that corresponds to each value. Remember that there are duplicate values in this set, not every value is unique.
In 'Last 20', the column titled 1 should be the last value, 2 should be the second last value, 20 should be the 20th to last value, and so on....
Thanks for any help in advance!
Bookmarks