Hello friend,
I would like to scroll the formula fill bottom, & using office 365
I am getting result in cell "I4" like this,Please Login or Register to view this content.
=100*G4/@INDIRECT("$G$"&@ROW(INDIRECT("J"&MAX(@ROW($3:3)*(@$J$3:J3<>"")))))
But my requirement is
=100*G4/INDIRECT("$G$"&ROW(INDIRECT("J"&MAX(ROW($3:3)*($J$3:J3<>"")))))
How I can remove this unnecessary @.
Thanks, RR
Bookmarks