Filter on non-blanks in a range (multiple columns)

[TKOSeanD]

I have a spreadsheet that has offers on parts from multiple
clients. The spreadsheet is 12,000 lines long. I am looking to
select on a range (of offers) and the highest offer gets put into a
BEST OFFER column on the same row.

Example

Part Number BestOffer Offer#1 Offer#2 Offer#3 Offer#4 Offer#5
xxxxxx-001 $13.00 $1.00 $5.25 $10.00 $3.50 $13.00
xxxxxx-002 $5.00 $1.25 $3.00 $5.00 $4.75 $8.00

The spreadsheet (12,000 lines long) has to remain in the same,
original format as it came in BEFORE I received these offers.

What is the best bet to address this?

 

[Max]

Assuming your source table is in cols A:G
In H2: =INDEX(C$1:G$1,MATCH(B2,C2:G2,0))
Copy down to return the Offer# corresponding to the amount under "Best
Offer" within each row. Should there be any tie(s) in the "Best Offer", the
expression will return the leftmost Offer#