It just looks for a very big number, and finds the nearest value to it, the
last in the range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"saziz" wrote in message
...

Hi Ron,
Can you pls explain :
=INDEX(A:A,MATCH(10^99,A:A))
the function of 10^99

thank you
Syed


Ron Coderre Wrote:
You have a few options:

1. The value of the last non-blank in Col_A:
=INDEX(A1:A65535,MATCH(2,1/(1-ISBLANK(A1:A65535))))
Note: Commit that array formula by holding down the [Ctrl][Shift] keys
and press [Enter].

2. The value of the last numeric value in Col_A:
=INDEX(A:A,MATCH(10^99,A:A))

3. The value of the last text value in Col_A:
=INDEX(A:A,MATCH(REPT("z",255),A:A))

Does that give you something to work with?

Regards,
Ron


--
saziz
------------------------------------------------------------------------
saziz's Profile:
http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=521186