Hello
I have a problem in my spreadsheet.
I can't figure out a way to show the last value i row 9 greater than 0.
I want the result (should be 1) to show in D7.
I have setup this spreadsheet in advanced settings, so that it doesn't show 0, but leaves cells blank if 0.
Hope anybody can help me on this.
Cheers,
Martin
Hi.
=LOOKUP(1,0/F9:AD9,F9:AD9)
In Danish:
=OPSLAG(1;0/F9:AD9;F9:AD9)
Regards
Hi
Thank you, but it doesn't work :-(
111.jpg
Last edited by Kaas; 08-19-2015 at 02:52 AM.
Apologies. Perhaps my translation was incorrect.
Maybe it's SLÅ.OP, not OPSLAG?
Regards
If you upload file it should convert it when Kass opens it
Two things: check that you didn't copy in a leading speace before the =. Is it possible that the last value will be in different columns for each group of 3 rows?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
SLÅ.OP did it.
Thank you XOR LX :-)
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks