Excel formula question

  Diver14 14:13 11 Mar 05
Locked

Is there a formula that will find the value within the last populated cell in a row or column?

  VoG II 14:37 11 Mar 05

Last value in Row B

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

  VoG II 14:38 11 Mar 05

Row 2, I mean

  VoG II 14:42 11 Mar 05

Last value in Column C

=INDEX(C:C,MATCH(0,C:C,-1))

  VoG II 14:50 11 Mar 05

Alternative for last value in Column C (for consistency).

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

  Diver14 15:29 11 Mar 05

I've just tried the first one =LOOKUP(9.99999999999999E+307,2:2 and it works a treat. If you have the time, could you explain it to me?

  Diver14 15:31 11 Mar 05

Sorry, I should have said - i understand the Vlookup but not the 9.9999 etc.

  VoG II 16:46 11 Mar 05

Explanation click here

  Diver14 17:12 11 Mar 05

Good grief - I wish I hadn't asked now!! High level stuff!!

Thanks again for your help.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…