Hi,
In the sheet in attchamment I would like in Column "G119" appears the last number of the same column ("G"), in this case it is "F9" and the value of 731,13 €, but with my formula appears a error.
thanks in advance
Hi,
In the sheet in attchamment I would like in Column "G119" appears the last number of the same column ("G"), in this case it is "F9" and the value of 731,13 €, but with my formula appears a error.
thanks in advance
No attachment ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Attach your workbook here, not in another thread!
Try this:
=LOOKUP(2,1/($F$7:$F$22<>"#NA"),$F$7:$F$22)
You may need to change commas to semi-colons for your European locale.
Sorry. I forget to put a attachament. I make a new one. Hope is well done.
thanks
See post #3 (and our rules regarding thread duplication, which is NOT allowed - attach the workbook HERE).
It doesn't work. Maybe I fill something wrong. It is possible you make it in the attchament ?? Thanks
it works now !!!! THANKS !!!
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks