Is there a formula that will find the value within the last populated cell in a row or column?
Last value in Row B=LOOKUP(9.99999999999999E+307,2:2)
Row 2, I mean
Last value in Column C=INDEX(C:C,MATCH(0,C:C,-1))
Alternative for last value in Column C (for consistency).=LOOKUP(9.99999999999999E+307,C:C)
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?
Sorry, I should have said - i understand the Vlookup but not the 9.9999 etc.
Explanation click here
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.
OnePlus 5 review
30 UK artists have created vibrant posters celebrating Pride London
iPad Pro 10.5in (2017) review
Comment connecter un MacBook à une TV ?
© Copyright 2017 IDG UK. All Rights Reserved.