Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up the last cell in a column
I am transfering a value in one cell to another worksheet. I need it to pull
the last cell in that column with data in it. The sheet that I need to pull from is a living document and changes daily. Can someone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up the last cell in a column
=LOOKUP(99^99,G:G)
will get the last NUMBERIC value in column G. Does this help? "BAKERSMAN" wrote: I am transfering a value in one cell to another worksheet. I need it to pull the last cell in that column with data in it. The sheet that I need to pull from is a living document and changes daily. Can someone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up the last cell in a column
It does a little. This only thing is that I am pulling data from a sheet that
is in a completely different workbook than the one that I am working in. "Toppers" wrote: =LOOKUP(99^99,G:G) will get the last NUMBERIC value in column G. Does this help? "BAKERSMAN" wrote: I am transfering a value in one cell to another worksheet. I need it to pull the last cell in that column with data in it. The sheet that I need to pull from is a living document and changes daily. Can someone help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up the last cell in a column
You obviously need to change the workbook/sheet references to any formula
that is given to adapt to your real life situation =LOOKUP(99^99,[Testme.xls]Sheet1!$G:$G) -- Regards, Peo Sjoblom "BAKERSMAN" wrote in message ... It does a little. This only thing is that I am pulling data from a sheet that is in a completely different workbook than the one that I am working in. "Toppers" wrote: =LOOKUP(99^99,G:G) will get the last NUMBERIC value in column G. Does this help? "BAKERSMAN" wrote: I am transfering a value in one cell to another worksheet. I need it to pull the last cell in that column with data in it. The sheet that I need to pull from is a living document and changes daily. Can someone help? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up the last cell in a column
Okay, I figured out how to lookup the last numerical value, how can i lookup
the last alpha numeric value? "Toppers" wrote: =LOOKUP(99^99,G:G) will get the last NUMBERIC value in column G. Does this help? "BAKERSMAN" wrote: I am transfering a value in one cell to another worksheet. I need it to pull the last cell in that column with data in it. The sheet that I need to pull from is a living document and changes daily. Can someone help? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up the last cell in a column
If there are no blank rows in-between
=INDEX(A:A,COUNTA(A:A)) will return last value in A regardless of gender (numerical/text) =LOOKUP(2,1/(A1:A65535<""),A1:A65535) will return last value where there can be empty/blank rows in-between -- Regards, Peo Sjoblom "BAKERSMAN" wrote in message ... Okay, I figured out how to lookup the last numerical value, how can i lookup the last alpha numeric value? "Toppers" wrote: =LOOKUP(99^99,G:G) will get the last NUMBERIC value in column G. Does this help? "BAKERSMAN" wrote: I am transfering a value in one cell to another worksheet. I need it to pull the last cell in that column with data in it. The sheet that I need to pull from is a living document and changes daily. Can someone help? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up the last cell in a column
On Jul 17, 6:54 am, BAKERSMAN
wrote: Okay, I figured out how to lookup the last numerical value, how can i lookup the last alpha numeric value? "Toppers" wrote: =LOOKUP(99^99,G:G) will get the last NUMBERIC value in column G. Does this help? "BAKERSMAN" wrote: I am transfering a value in one cell to another worksheet. I need it to pull the last cell in that column with data in it. The sheet that I need to pull from is a living document and changes daily. Can someone help? =LOOKUP(REPT("z",255),[Testme.xls]Sheet1!$G:$G) Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
Hide column or row based on a cell in the column or row? | Excel Discussion (Misc queries) | |||
Fill handle - new column using a column and one cell | Excel Discussion (Misc queries) | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) |