I have a column of text data. I'm looking for a simple formula to return the row number where the text value changes.
A B
1 Zulu
2 Apple
3 Apple
4 Apple
5 Zulu
6 Zulu
7 Baker
8 Baker
9 Charlie
10 Charlie
In the list above, I'd like to know that given "Zulu" as an input in cell $b$1, the formula would return 7 (the row where Zulu has changed to Baker).
A B
1 Zulu
2 Apple
3 Apple
4 Apple
5 Zulu
6 Zulu
7 Baker
8 Baker
9 Charlie
10 Charlie
In the list above, I'd like to know that given "Zulu" as an input in cell $b$1, the formula would return 7 (the row where Zulu has changed to Baker).