Hello,
I am struggling to figure out how to find the last Occurrence in a table and return the value on the cell above it with simple Excel formula. Please help
For example: i want to find the last occurrence for "a" in the following table, it would return c
I am struggling to figure out how to find the last Occurrence in a table and return the value on the cell above it with simple Excel formula. Please help
For example: i want to find the last occurrence for "a" in the following table, it would return c
a | b | a |
a | a | c |
a | b | a |