Hi all, I hope you can help, and thanks in advance for taking a look! I would like a formula where the output is the cell location of the last occurrence of the word "yes" in column D. So, let's say the word "yes" appears in D4, D9, D27, D32... I would want the result/output of the formula to read "D32." I hope I'm explaining this clearly. Thanks! -Mark