Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a formula to transfer the last value in a column
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!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a formula to transfer the last value in a column
Peo,
permit me to add a bit of spice! say Sheet1 is where column A with values exist. say sheet 2 - where u want to copy/link the value =LOOKUP(2,1/(Sheet1!A1:A65535<""),Sheet1!A1:A65535) yet to litteraly *transfer* the last value, i suggest to cut and paste the desired last value from sheet1 to sheet2... "Peo Sjoblom" wrote: 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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column/Row Transfer Question | Excel Discussion (Misc queries) | |||
add numbers in a column and transfer result to another column | Excel Worksheet Functions | |||
Formula to transfer and add data with date. | Excel Discussion (Misc queries) | |||
transfer data from one column into another column | Excel Discussion (Misc queries) | |||
How is it that a cell can transfer the correct formula, but the w. | Excel Discussion (Misc queries) |