I have a column of text values listed below. I need the position of the last text value which is 7, however, the situation is complicated by the fact that the cells that appear blank contain the null string [""]. So, I keep getting the answer 9 when trying to use some of the conventional formulas. From cells 10 and down the cells are truely blank.
A
1 Orange
2 Orange
3
4 Bannana
5
6 Apple
7 Orange
8
9
Bookmarks