S
starguy
i have row totals in a range that is H5:H25, but some cells in this
range may have nill value (despite that formula exists). i want to show
the last value in this range in cell H27.
suppose i have a value in H5, H6, and H7 (remaining cells i-e H8:H25
have nill value) i want to show in H27 the last value in that range
which is now in H7.
similarly if the values in range H5:H25 change the cell H7 should
automatically update to the last value appearing in H5:H25.
is there any way?
your expert advice will be appreciated.
i m waiting for quick reply.
thanks.
range may have nill value (despite that formula exists). i want to show
the last value in this range in cell H27.
suppose i have a value in H5, H6, and H7 (remaining cells i-e H8:H25
have nill value) i want to show in H27 the last value in that range
which is now in H7.
similarly if the values in range H5:H25 change the cell H7 should
automatically update to the last value appearing in H5:H25.
is there any way?
your expert advice will be appreciated.
i m waiting for quick reply.
thanks.