To get the row number of a cell, is ROW faster or ROWS faster?
For example
ROW(A20) vs ROWS($A$1:A20), which one is faster?
I have hundreds of thousands of formulas containing these (many are inputs for other formulas) and I want to pick the more efficient one.
(Furthermore, how about simply ROW() without parameter on the row where the target cell is located. Is it the fastest?)
Thanks.
Bookmarks