Best Price With Excel INDEX and MATCH

Описание к видео Best Price With Excel INDEX and MATCH

Combine the Excel function INDEX with MATCH and MIN, to find the store that has the best price on an item.

The MIN function calculates the lowest price, then MATCH finds the position of that price, and INDEX returns the store name for the selected column.


http://www.contextures.com/xlFunction...


Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips

Комментарии

Информация по комментариям в разработке

Похожие видео