Hi hope someone can help. Using the following formula =MAX(B14,D14,F14,H14,J14), but is not really capturing the cost value that I need. I need to capture the cost from the last cell that has a value in it that is not 0, the cost can fluctuate so the MAX does not work.
hi shymac, perhaps
=LOOKUP(2,1/((MOD(COLUMN(B14:J14),2)=0)*(B14:J14<>0)),B14:J14)
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
This looks like it will work just needs to be tweaked a little, how do I get rid of #N/A and return 0
Last edited by shymac; 03-20-2013 at 09:30 AM.
Cross-post here, BTW.
Everyone who confuses correlation and causation ends up dead.
Thanks works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks