Formula to identify duplicate low bidder

[jblack]

Hi Forum,

In the uploaded file I have set up a bid analysis to determine the low bidder for each bid item. I am using the MIN function to determine the low bid and I am using Index and Match to pull the low bidder name. If there are duplicate low bids, I am using Conditional Formatting for duplicates to highlight those duplicates. What I am having trouble with is that in column I of my spreadsheet I would like to show the name of the other vendor who is also the low bidder and if there were 3 low bidders duplicates show the name of the other bidder in Column J, etc. Does anyone have a solution for this? Thanks in advance for your help.

 

[wudixin96]

Array Formula

Ctrl+Shift+Enter

 

[jblack]

Array Formula

Ctrl+Shift+Enter

Hi wudixin96,

Thanks for the solution to my problem. I'm trying to figure out what the formula does. Could you explain what is happening in this section of the formula: INDEX($A$2:$F$2,,SMALL(IF($B3:$F3=$G3,COLUMN($B:$F)),COLUMN(B$3))