Loading video...

Video Failed to Load

Go Home

Use of TAKE, SORT & FILTER Function in Microsoft #Excel using Dynamic Array Formula (HR Example) | How to get TOP n | BOTTOM n | TOP 3 (Criteria) TOP 5: =TAKE(SORT(Data,3,-1),5) BOTTOM 5: =TAKE(SORT(Data,3,1),5)

ExcelBasement's profile picture

Excel Basement

33,717 subscribers

228,343 views • 3 years ago •via X (Twitter)

#Excel
LIVE

Anya Rossi• Live Now

Private livecam show

0 Comments

No comments available

Comments from the original post will appear here

Related Videos

How to use FILTER Function in Excel - Dynamic Filter Formula #Excel #FILTER ======================== Subscribe: ========================
0:46

How to use FILTER Function in Excel - Dynamic Filter Formula #Excel #FILTER ======================== Subscribe: ========================

Learn Excel to excel

20,644 views • 3 months ago

Here’s how Trump’s tax plan would take from the bottom 95% to benefit the top 5%
1:29

Here’s how Trump’s tax plan would take from the bottom 95% to benefit the top 5%

NowThis Impact

14,504 views • 1 year ago

How to use SCAN Function in Excel - Calculate Running Totals with Dynamic Array Formula #SCAN #Excel ======================== Subscribe: ========================
0:31

How to use SCAN Function in Excel - Calculate Running Totals with Dynamic Array Formula #SCAN #Excel ======================== Subscribe: ========================

Learn Excel to excel

10,951 views • 3 months ago

Bottom 5 in payroll, top 5 farm system, and top 5 in all of baseball. We are not worthy 🙇🏻‍♂️
0:36

Bottom 5 in payroll, top 5 farm system, and top 5 in all of baseball. We are not worthy 🙇🏻‍♂️

Gateway Grinders

127,669 views • 1 month ago

.Dr. Rhonda Patrick' top 5 supplements to take: • Omega-3 • Vitamin D • Sulforaphane • Magnesium • Multivitamin
0:52

.Dr. Rhonda Patrick' top 5 supplements to take: • Omega-3 • Vitamin D • Sulforaphane • Magnesium • Multivitamin

FoundMyFitness Clips

48,321 views • 1 year ago

the top 5 dunks in grizzlies history according to Devin Walker presented by Take 5 Oil Change
1:46

the top 5 dunks in grizzlies history according to Devin Walker presented by Take 5 Oil Change

Grind City Media

39,900 views • 1 year ago

Akademiks reveals KD’s top 5 Drake albums (before Her Loss and subsequent albums dropped): 1. Take Care 2. IYRTITL 3. CLB 4. Scorpion 5. NWTS
0:40

Akademiks reveals KD’s top 5 Drake albums (before Her Loss and subsequent albums dropped): 1. Take Care 2. IYRTITL 3. CLB 4. Scorpion 5. NWTS

Akademiks TV

51,290 views • 3 months ago

Stephen A Smith gives his top 5 Wrestlers of all time: 1. Goldberg 2. Ric Flair 3. Hulk Hogan 4. The Rock 5. Road Warriors (First Take ESPN)
1:41

Stephen A Smith gives his top 5 Wrestlers of all time: 1. Goldberg 2. Ric Flair 3. Hulk Hogan 4. The Rock 5. Road Warriors (First Take ESPN)

FADE

105,967 views • 8 months ago

Top 5 plays from 2024-25 😤 #TTW | Take 5 Oil Change
0:52

Top 5 plays from 2024-25 😤 #TTW | Take 5 Oil Change

Texas Tech Basketball

19,627 views • 1 year ago

Who are your top 5 retired Panthers Legends? Take 5 Oil Change | #KeepPounding
0:58

Who are your top 5 retired Panthers Legends? Take 5 Oil Change | #KeepPounding

Carolina Panthers

457,988 views • 1 year ago

Learn Sharp: Book mark it: 1.Head&Shoulders 2.Double Top 3.Double Bottom 4.Symmetrical Triangle 5.Ascending Triangle Etc.
0:51

Learn Sharp: Book mark it: 1.Head&Shoulders 2.Double Top 3.Double Bottom 4.Symmetrical Triangle 5.Ascending Triangle Etc.

Market Rebellion

22,933 views • 4 months ago

Cody Rhodes gives us his top 5 #WrestleMania wrestlers of all time. 1. Hulk Hogan 2. Roman Reigns 3. Shawn Michaels 4. Macho Man 5. Charlotte Flair (First Take ESPN)
1:01

Cody Rhodes gives us his top 5 #WrestleMania wrestlers of all time. 1. Hulk Hogan 2. Roman Reigns 3. Shawn Michaels 4. Macho Man 5. Charlotte Flair (First Take ESPN)

FADE

160,105 views • 2 months ago

Top 5 plays of the season according to the content team. How'd we do? #WreckEm | Take 5 Oil Change
1:37

Top 5 plays of the season according to the content team. How'd we do? #WreckEm | Take 5 Oil Change

Texas Tech Football

12,518 views • 1 year ago

RJMrLA DEMANDS HIS RESPECT FROM LA HIP HOP‼️ "TOP 5, TOP 3. N*GGA, RJMrLA. THAT'S WHAT IT IS."
1:28

RJMrLA DEMANDS HIS RESPECT FROM LA HIP HOP‼️ "TOP 5, TOP 3. N*GGA, RJMrLA. THAT'S WHAT IT IS."

Backonfigg

13,549 views • 11 months ago

Is Jalen Hurts a Top 5 QB? Pardon My Take
1:30

Is Jalen Hurts a Top 5 QB? Pardon My Take

Barstool Sports

154,978 views • 1 year ago

5月の横渋春パークTop to bottom
1:07

5月の横渋春パークTop to bottom

ごえ

18,780 views • 1 year ago

Pete Crow-Armstrong yesterday: Top 3 - 101.7 mph Single Top 5 - 110.3 mph Double Top 8 - 114.6 mph Home Run Top 9 - 98.2 mph Single Bottom 9 - 5 Star Catch (5% Catch Prob) Since being moved to the leadoff spot: .290/.410/.484 — 156 wRC+ 81.1% Hard-Hit% | .517 xwOBA | 0.5 fWAR
0:55

Pete Crow-Armstrong yesterday: Top 3 - 101.7 mph Single Top 5 - 110.3 mph Double Top 8 - 114.6 mph Home Run Top 9 - 98.2 mph Single Bottom 9 - 5 Star Catch (5% Catch Prob) Since being moved to the leadoff spot: .290/.410/.484 — 156 wRC+ 81.1% Hard-Hit% | .517 xwOBA | 0.5 fWAR

Carson Wolf

66,320 views • 13 days ago

My Top 5 Actors of All-Time: 1. Jack Nicholson 2. Denzel Washington 3. Robert DeNiro 4. Paul Newman 5. Sidney Poitier Ernestine's Top 5: 1. Al Pachino 2. Robert Redford 3. Robert DeNiro 4. Cary Grant 5. Richard Gere
7:32

My Top 5 Actors of All-Time: 1. Jack Nicholson 2. Denzel Washington 3. Robert DeNiro 4. Paul Newman 5. Sidney Poitier Ernestine's Top 5: 1. Al Pachino 2. Robert Redford 3. Robert DeNiro 4. Cary Grant 5. Richard Gere

Skip Bayless

242,027 views • 1 year ago

Let’s take it from the top. Stream Bono & The Edge: A Sort of Homecoming with Dave Letterman, an Original documentary special, March 17 on #DisneyPlus.
2:22

Let’s take it from the top. Stream Bono & The Edge: A Sort of Homecoming with Dave Letterman, an Original documentary special, March 17 on #DisneyPlus.

David Letterman

717,114 views • 3 years ago

We got a top 5 Denzel Washington movie & a top 5 JAY-Z album out of it. Hov started & finished the album in 3 weeks 🤯
1:12

We got a top 5 Denzel Washington movie & a top 5 JAY-Z album out of it. Hov started & finished the album in 3 weeks 🤯

💎🍾

265,919 views • 7 months ago