I am trying to figure out how to write a formula that returns the MIN bid. The catch is that I have bids from 40 different bidders. I want to take the minimum bid of a specific group of 10 of those bidders. So, A, B, C, D, E, F, G each submitted bids, but I want to return the MIN bid from C, E, and G. I am not properly writing the formula (which I assume will be an array with a MIN and an IF statement).
Bookmarks