nth Last Entry With A Specific Name
So basically I need to find the last, 2nd last, 3rd last, 4th last, 5th last, 6th last and 7th last entries in a sheet that have a specific name. Each of the nth entries will go in a separate column on a new sheet. I was thinking about using INDEX but am unsure how to find the nth row number the name is = to the one I'm looking for. New entries are being put into the sheet about 100 times a day but normally not more than once per name.
Help Article Resources
Check out the Formula Handbook template!