Hello brainstrust,
First time poster so apologise for poor lingo.
Looking for a formula(s) to return the 8 most recent non-blank values from a table where condition 'X' is met.
Have been trying things like (for first, then third most recent ammonia result at location 1):
{=IF(Table1[Sample Location] = 1, VLOOKUP(MAX(Table1[Date]), Table1[#All], 14, FALSE), "")}
{=IF(Table1[Sample Location] = 1, VLOOKUP(LARGE(Table1[Date], 2), Table1[#All], 14, FALSE), "")}
Date is in dd/mm/yyyy format.
Max formula seems to work, but each subsequent rendition of large k is providing me the same output as the max?
Appreciate your help! Please find a small section of the workbook attached.
Bookmarks