H Himanshu New Member Sep 17, 2011 #1 Hi Everyone, There is a function called "offset" which helps to select the dynamic data range. I am wondering if there is any way i can select data till the second last row not the last row using this formula. Thanks in advance
Hi Everyone, There is a function called "offset" which helps to select the dynamic data range. I am wondering if there is any way i can select data till the second last row not the last row using this formula. Thanks in advance
Hui Excel Ninja Staff member Sep 17, 2011 #2 =offset(x,y,counta(col : col)-1,0) Adjust the -1 component to suit
