Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to Find End Value of a Column with Unknown End Range
I have a need to find the Last Value of a Column where the
max rows varies from day to day. Does anyone know how to auto find this end value of the column via code without know how many rows will be in the column? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to Find End Value of a Column with Unknown End Range
Via code (assuming col c):
LastVal = Range("C65536").end(xlup).value Via cell formula: ctrl/shift/enter: =INDEX(C:C,MAX((C1:C20000<"")*row(1:20000)) -----Original Message----- I have a need to find the Last Value of a Column where the max rows varies from day to day. Does anyone know how to auto find this end value of the column via code without know how many rows will be in the column? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to Find End Value of a Column with Unknown End Range
If there are only numbers in the column or at least the last filled cell
will be a number, this will be a much faster formula than an array formula: =INDEX(D:D,MATCH(9.99999999999999E+307,D:D,1),1) -- Regards, Tom Ogilvy Bob Umlas wrote in message ... Via code (assuming col c): LastVal = Range("C65536").end(xlup).value Via cell formula: ctrl/shift/enter: =INDEX(C:C,MAX((C1:C20000<"")*row(1:20000)) -----Original Message----- I have a need to find the Last Value of a Column where the max rows varies from day to day. Does anyone know how to auto find this end value of the column via code without know how many rows will be in the column? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! Unknown range | Excel Worksheet Functions | |||
How do I find unknown interest rate using TVM functions | Excel Worksheet Functions | |||
Find & replace a value in an unknown cell location | Excel Discussion (Misc queries) | |||
How do I find an unknown value on a line made from known data? | Excel Discussion (Misc queries) | |||
How to find out merge cells from unknown position | Excel Discussion (Misc queries) |