J
Jkulak
I am trying to find the lowest bid in a range of bids and in an adjacen
cell put the NAME of the bidder in that cell. I can find the lo
bidder using the min function but the lookup functions I'm trying t
use only work if the range is sorted. I don't have this luxury becaus
of the size of the date. Is there a fix for this?
Bidder Joe 1 / Joe 2 / Joe 3 Low Bid / Low Bidder
Bid 36 / 25 / 45 25 / Joe
cell put the NAME of the bidder in that cell. I can find the lo
bidder using the min function but the lookup functions I'm trying t
use only work if the range is sorted. I don't have this luxury becaus
of the size of the date. Is there a fix for this?
Bidder Joe 1 / Joe 2 / Joe 3 Low Bid / Low Bidder
Bid 36 / 25 / 45 25 / Joe