Penultimate cell
Tks
"Gord Dibben" wrote:
=OFFSET(INDEX(B:B,MATCH(99^99,B:B)),-1,0) for the penultimate numeric value
=OFFSET(INDEX(B:B,MATCH(REPT("z",255),B:B)),-1,0) for the penultimate text
value.
Gord Dibben MS Excel MVP
On Fri, 8 Feb 2008 06:23:01 -0800, Antonio
wrote:
Tks for the help....
When I try the formulas, they return the last filled cell, and not the
penultimate... M I missing something???
Tks again
"Mike H" wrote:
Hi,
In a macro use
penultimatevalue = Cells(Rows.Count, "A").End(xlUp)
On a worksheet for text use
=INDEX(B:B,MATCH(REPT("z",10),B:B,1),1)
for a number number
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
if you don't know if its a number or text
=INDIRECT("B"&MAX(IF(NOT(ISBLANK(B1:B100)),ROW(1:1 00))))
Which is an array so Ctrl+Shift+Enter
Mike
"Antonio" wrote:
Hi all
Is there anyway to extract the contents of the penultimate filled cell
Tks in advance
|