Only show last value entered in a row

R

Ron Rosenfeld

Need formula to only show last value entered in a row.

Tom
Click to expand...

For Row 1 **Array-Entered**

=INDEX(1:1,1,MAX(NOT(ISBLANK(1:1))*COLUMN(1:1)))

To *array-enter*, type or paste the formula in, then hold down <ctrl><shift>
while hitting <enter>. XL will place braces {...} around the formula.


--ron
 
G

Gord Dibben

If numeric value..

=LOOKUP(9.99999999999999E+307,1:1)

If not a numeric value

=LOOKUP(REPT("z",255),1:1)

Note: both formulas assume you are looking in row 1. Alter to suit.

Gord Dibben Excel MVP
 
P

picktr

Mr. Dibben,

=LOOKUP(9.99999999999999E+307,1:1)

I need to put this formula in a seperate worksheet
from the one it is referencing.

worksheet1! ref range (J4:AD4)

also, it needs to = the value of the cell, text or number

I apologize for not being more specific in my 1st post.

Tom Picket
 
G

Gord Dibben

Try this one. Returns contents of last filled cell in the range j4:ad4

=INDEX(worksheet1!J4:AD4,MAX(MATCH(9.99999999999999E+307,worksheet1!J4:AD4),MATCH(REPT(CHAR(255),255),worksheet1!J4:AD4)))

A Frank Kabel creation.

Gord
 
Top