Excel Forum

Excel Magic Trick 518: Show Multiple Vendor Names Associated With Low Bid Array Formula INDEX

See how to use INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display multiple vendor names when multiple vendors are ties for low bid.

Got a Question? Ask it Here in the Forum.