I used a formula [MATCH(9.9E307,A:A,1)] to find the last cell in column A. It returns a value of 1912 because that is the last row with data (not to actual cell value) in column A. Now I want to determine what the value is in A1912. I know I can do [=A1912] but the last cell will change all the time in my spreadsheet. I want to avoid typing in the last cell number. How can I do this automatically? Thanks
Try
=INDEX(A:A,MATCH(9.9E307,A:A,1),1)
Or this
Formula:
Please Login or Register to view this content.
if A:A contains text use
Formula:Please Login or Register to view this content.
and for numbers
Formula:Please Login or Register to view this content.
Last edited by AlKey; 09-09-2016 at 10:37 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I got the last o e to workOriginally Posted by AlKey
Or this
Formula:Please Login or Register to view this content.
if A:A contains text use
Formula:Please Login or Register to view this content.
and for numbers
Formula:Please Login or Register to view this content.
Last edited by HDeuce; 09-09-2016 at 10:57 AM.
Ok, you have mixed values
Formula:Please Login or Register to view this content.
Thank you AlKey. I got the number one to work. I tried the mixed values one and i got an error saying "excel ran out of resources while attempting to calculate one or more formulas"Ok, you have mixed values
Formula:Please Login or Register to view this content.
Either way the lookup(10^308,A:A) worked...thanks
You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks