Is there a formula to transfer the last value in a column
Column A
=LOOKUP(2,1/(A1:A65535<""),A1:A65535)
--
Regards,
Peo Sjoblom
"Tam" wrote in message
...
I have all $ amounts in the column. I need a formula that picks up the last
value in the column and transfers it to another cell in another worksheet.
Is
there a formula to do that? Thanks......Need this As Soon As Possible!!!!
|