Hi
I would like a formula that returns the Best margin from a range of cells, yet ignores the cell with 100% margin (as the manufacturer does not sell this product)
Or can i hide the 100% result in my original calculation?
Any help appreciated
Thanks
In K2,
=LARGE(G2:J2, COUNTIF(G2:J2,1) + 1)
If in G2 you used
=IF(B2, 1-B2/$F2, "")
... which you could copy across and down, a simple MAX formula would work in K2.
Last edited by shg; 02-27-2014 at 09:36 PM.
Entia non sunt multiplicanda sine necessitate
Thats great, thanks SHG
Would i use this formula to work out the second best? Or is that not how it works?
=LARGE(G2:J2, COUNTIF(G2:J2,2) + 1)
=large(g2:j2, countif(g2:j2,1) + 2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks