I need to return the largest row number in a column which contains a certain value. I am thinking I can use a combination of Max and Match as an array formula, but I'm a little stuck. Imagine the following five values are in column A and I want to return the greatest row number containing "Dog":

Cat

Dog

Dog

Dog

Dog

I would expect the formula to return 5. Any ideas? Thanks!