Excel AI Assistant

Here's a powerful LOOKUP formula to find the last occurrence of a value in column A:

=LOOKUP(2,1/(A:A=value),ROW(A:A))

​

This works by creating an array of TRUE/FALSE values where your target appears, converting them to 1's and 0's, then finding the last position. Let me explain how...