Find Lowest Bidder

[Jkulak]

I am trying to find the lowest bid in a range of bids and in an adjacent cell put the NAME of the bidder in that cell. I can find the low bidder using the min function but the lookup functions I'm trying to use only work if the range is sorted. I don't have this luxury because 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 / Joe2

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Jkulak]

Bernie, thank you, it's working beautifully. J

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP


"Jkulak" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to find the lowest bid in a range of bids and in an adjacent
> cell put the NAME of the bidder in that cell. I can find the low
> bidder using the min function but the lookup functions I'm trying to
> use only work if the range is sorted. I don't have this luxury because
> 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 / Joe2
>
>
> --
> Jkulak
> ------------------------------------------------------------------------
> Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
> View this thread: http://www.excelforum.com/showthread...hreadid=394636
>