For example, I freeze pane for row 1, and want A1 cell to display "Text1"
when windows is scrolling within row 2~100, and display "Text2" when it's
scrolled beyond row 101, can I use such formula in A1:
=if(GetCurrentTopRow() < 100, "Text1", "Text2")
is there such a function?
Bookmarks