I have a question similar to this one but with large values.
The results I tried there didn't give me the answer I was looking for.
I have a personal budget in a excel 2007 spreadsheet and want to return the last value in a row. The numbers are monetary values, so not within the 0-5 range of the question linked to.
Can anyone offer a formula to help with this? Much appreciated!
I am little bit confused about your requirement because of
expecting to pull Large value from the range or return last non zero value?Return last non-zero value from a row of data - large values.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
without seeing what data/format you are working with, try something like this...
=OFFSET(A2,0,COUNTA(A2:G2)-1)
adjust ranges as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Something along the lines ofreturns the last numeric value in row1
Please Login or Register to view this content.
hi sburm, welcome to the forum. maybe an array like below if your data is in row 2?
=LOOKUP(90000000000,IF(2:2<>0,2:2))
you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER. change the 2 accordingly to your row. if it's for column, then change to something like "A:A" for column A
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
last non zero value is
=LOOKUP(2,1/A2:Z2,A2:Z2)
Last edited by martindwilson; 11-27-2012 at 08:57 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Ah, what I am looking for is to pull the last non-zero number from a row but the answers in the link didn't work for large numbers - they only worked when the numbers in the row were between 0 and 5. Because I am dealing with monetray figures, the numbers are larger. But regardless, I want the last non-zero value in the row.Originally Posted by :) Sixthsense :)
Last edited by sburm; 12-09-2012 at 10:24 PM.
can you provide with a sample workbook with data and put a sample expected ouput so other's could play with it. thanks.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
And here is the solution! Thanks very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks