krishnaa_kum
10-16-2014, 06:31 AM
HI,
Does anyone knows how to generate automatic row number .
Example:
I have data from coloumn A till coloumn O. I would like to generate automatic row number in coloumn O only if the particular row is filled.
I tried using formula row() but it gives u row number for all the cells. I just want row number for active cells.
Thanks
Does anyone knows how to generate automatic row number .
Example:
I have data from coloumn A till coloumn O. I would like to generate automatic row number in coloumn O only if the particular row is filled.
I tried using formula row() but it gives u row number for all the cells. I just want row number for active cells.
Thanks