How to return the most recent text for a given value?
How can I return the most recent text from a cell, setting a criterion? I tried to use the formula =INDEX(), MATCH() -1, I understood that the "-1" in the formula would return values in descending order, but when I apply the formula the column repeats the same value found in the cell where I applied the formula to the others. I tried to use the MAX(COLLECT) function, but it only returns numbers, not text.
Help Article Resources
Check out the Formula Handbook template!