🥇🥈🥉Top N Values | Easy Solution with NEW Dynamic Arrays (macOS & Windows)

preview_player
Показать описание
Learn how to extract top values using the function LARGE and compare the value with column and applying the new dynamic arrays function Sequence, Filter, SORT. applicable for office365 macOS & Windows users only.

👍🏻 Like us on Facebook

👥Join The Facebook Group -
***********************************************************
You can check the following videos as well
🔎Find The Missing Number from the list | NEW Dynamic Arrays (macOS & Windows)
-----------------------------------------------
🧮Count Occurrence Or Add Index Number To Group Data | Power Query & PowerBI
-----------------------------------------------
Generate Month Calendar 📅& Ideas 💡 | Dynamic Arrays
-----------------------------------------------
📊 Averaging Top Values, LARGE, SEQUENCE | Classic & Dynamic Arrays
-----------------------------------------------
🤖Excel New Ai Engine | 📸Insert Data From Picture
***********************************************************
#DynamicArrays #MicrosoftCreators #ProductivityHack #FarazExcelMaster #FarazShaikh
Рекомендации по теме
Комментарии
Автор

BRILLIANT BRILLIANT BRILLIANT! I love the tips. I love the video--including the broken glass for those sneaky hidden spaces. WOW!
Excellent work.

OzduSoleilDATA
Автор

Great job. Your explanation is very clear. Much appreciated your work

ashok
Автор

This is really interesting one. It will helpfull.

shantaveeragouda.v.bachala
Автор

...for Sr.no column can be used only =SEQUENCE(G2)

Excelambda
Автор

Hi, what if i need another Criteria, say, Top 3 in France? please help.

larrybansjaw
Автор

After you enter function, how it is entered in all cells without dragging or copying? Is it because of feature of office insider? Please answer

rajanghadi