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.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch