Excel Magic Trick 1511: Array Formula: Get Low Bid From Supplier When Delivery Less Than 20 Weeks

Download File:
https://ift.tt/2AcigSi
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

In this video see how to create an Array Formula to get the low bid from Supplier when Deliver is Less Than 20 Weeks, and when the Data Set is not in Proper Data Set Form, which makes the formula a bit tricky. See the MIN and IF Functions that use Array Operations.

View on YouTube