Dynamic Named Ranges in Excel

preview_player
Показать описание
This video demonstrates how to create and use dynamic named ranges in Microsoft Excel. Functions often used with dynamic named ranges including SUM, SUMIF, AVERAGE, AVERAGEIF, MEDIAN, MODE, COUNTA, COUNTIF, MIN, and MAX are reviewed.
Рекомендации по теме
Комментарии
Автор

Thank you Dr. Grande! Is it possible to do name ranges that can filter out the blank cell? The objective here is make a dropdown list.

GnaChao