For Example, consider In excel you have 10 rows and you hid 5 rows in excel. I want the R1c1 rotation formula that calculates base on the visible cells in excel. that look like R[-4]C-R[-5]C. It is calculating the hidden rows also.
Any Help really appreciated.
Any Help really appreciated.