Excel formula question

  Diver14 14:13 11 Mar 2005

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 2005

Last value in Row B


  VoG II 14:38 11 Mar 2005

Row 2, I mean

  VoG II 14:42 11 Mar 2005

Last value in Column C


  VoG II 14:50 11 Mar 2005

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


  Diver14 15:29 11 Mar 2005

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 2005

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

  VoG II 16:46 11 Mar 2005

Explanation click here

  Diver14 17:12 11 Mar 2005

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.

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?