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
Bookmarks