Loading video...

Video Failed to Load

Go Home

How to Extract the TOP Marks Attained in Microsoft #EXCEL 365 =MAX(--TEXTSPLIT(TEXTJOIN(", ",,TEXTSPLIT(C4,TEXTSPLIT(C4,SEQUENCE(10,,0),,1),,1)),", "))

ExcelBasement's profile picture

Excel Basement

33,750 subscribers

25,565 views • 2 years ago •via X (Twitter)

#EXCEL
LIVE

Anya Rossi• Live Now

Private livecam show

1 Comments

CrispEXCEL Training & Consulting's profile picture
CrispEXCEL Training & Consulting2 years ago

Your solution to the challenge was insightful...incase anyone wants to see alternative solutions:

Related Videos

How to Split Text with Multiple Delimiters in Microsoft #Excel | TEXTSPLIT Function
0:56

How to Split Text with Multiple Delimiters in Microsoft #Excel | TEXTSPLIT Function

Excel Basement

173,555 views • 3 years ago

Count / Sum Multiple Values in a Cell (Excel 365 Version) =COUNT(--TEXTSPLIT(MID(B5,2,LEN(B5)-2),{",","&"})) =SUM(--TEXTSPLIT(MID(B10,2,LEN(B10)-2),{",","&"})) =COUNTA(--TEXTSPLIT(MID(B14,2,LEN(B14)-2),{",","&"}))
0:54

Count / Sum Multiple Values in a Cell (Excel 365 Version) =COUNT(--TEXTSPLIT(MID(B5,2,LEN(B5)-2),{",","&"})) =SUM(--TEXTSPLIT(MID(B10,2,LEN(B10)-2),{",","&"})) =COUNTA(--TEXTSPLIT(MID(B14,2,LEN(B14)-2),{",","&"}))

Excel Basement

23,102 views • 2 years ago

How to use TEXTSPLIT in Excel‼️ ❤️ and follow CheatSheets for daily tips‼️ #excel
0:30

How to use TEXTSPLIT in Excel‼️ ❤️ and follow CheatSheets for daily tips‼️ #excel

CheatSheets

98,096 views • 2 years ago

📊 Master the TEXTSPLIT Function in Excel Still separating text manually? The TEXTSPLIT function lets you split text into multiple columns or rows instantly using a delimiter such as commas, spaces, hyphens, or other characters. Why TEXTSPLIT is Useful ✅ Clean messy datasets faster ✅ Separate names, emails, and addresses automatically ✅ Save time on repetitive text processing ✅ Improve data preparation for analysis ✅ Replace manual Text-to-Columns workflows (Save this for later).
0:25

📊 Master the TEXTSPLIT Function in Excel Still separating text manually? The TEXTSPLIT function lets you split text into multiple columns or rows instantly using a delimiter such as commas, spaces, hyphens, or other characters. Why TEXTSPLIT is Useful ✅ Clean messy datasets faster ✅ Separate names, emails, and addresses automatically ✅ Save time on repetitive text processing ✅ Improve data preparation for analysis ✅ Replace manual Text-to-Columns workflows (Save this for later).

Tips Excel

18,005 views • 2 months ago

Extract First, Middle & Last Names from a list of Names in Microsoft #Excel 365 First Name: =TEXTBEFORE(B4," ") Middle Name: =IFNA(TEXTBEFORE(TEXTAFTER(B4, " "), " "),"") Last Name: =TEXTAFTER(B4," ",-1)
0:49

Extract First, Middle & Last Names from a list of Names in Microsoft #Excel 365 First Name: =TEXTBEFORE(B4," ") Middle Name: =IFNA(TEXTBEFORE(TEXTAFTER(B4, " "), " "),"") Last Name: =TEXTAFTER(B4," ",-1)

Excel Basement

20,409 views • 2 years ago

Currency Exchange Rate Tracker (USD) in Microsoft #Excel 365 and Google Sheets Excel | =STOCKHISTORY(B4,TODAY()-1,TODAY(),0,0,1) Google Sheets | =GOOGLEFINANCE("USDEUR") OR =IFERROR(GOOGLEFINANCE(C3),"")
0:28

Currency Exchange Rate Tracker (USD) in Microsoft #Excel 365 and Google Sheets Excel | =STOCKHISTORY(B4,TODAY()-1,TODAY(),0,0,1) Google Sheets | =GOOGLEFINANCE("USDEUR") OR =IFERROR(GOOGLEFINANCE(C3),"")

Excel Basement

10,623 views • 2 years ago

Mari Bedah Formula 1. LET → Menamai formula 2. WRAPROWS → Membungkus array, 1 baris berisi n kolom 3. VLOOKUP → Mencari nilai berdasarkan kode 4. TEXTSPLIT → Memecah kode berdasarkan delimiter "/" 5. TEXTJOIN → Menggabungkan kode dengan delimiter "/" 6. HSTACK → Menyusun array secara horisontal 7. XLOOKUP → Mencari harga 8. CHOOSECOLS → Mengambil kolom ke-n dari suatu array Apakah penggunaan rumus diatas adalah efisien? terntunya tidak, lebih ke arah eksplorasi dan menambah wawasan formula. 😁😁 Lalu pake apa? Coba ganti IF pakai SWITCH atau pakai VLOOKUP dgn array konstan (tidak perlu tabel bantu).
0:22

Mari Bedah Formula 1. LET → Menamai formula 2. WRAPROWS → Membungkus array, 1 baris berisi n kolom 3. VLOOKUP → Mencari nilai berdasarkan kode 4. TEXTSPLIT → Memecah kode berdasarkan delimiter "/" 5. TEXTJOIN → Menggabungkan kode dengan delimiter "/" 6. HSTACK → Menyusun array secara horisontal 7. XLOOKUP → Mencari harga 8. CHOOSECOLS → Mengambil kolom ke-n dari suatu array Apakah penggunaan rumus diatas adalah efisien? terntunya tidak, lebih ke arah eksplorasi dan menambah wawasan formula. 😁😁 Lalu pake apa? Coba ganti IF pakai SWITCH atau pakai VLOOKUP dgn array konstan (tidak perlu tabel bantu).

Tanya Jawab Excel 📊📊

32,719 views • 3 months ago

Microsoft 365 Copilot in Excel with Python, now in preview, allows you to: ➡️ Perform advanced data analysis ➡️ Create sophisticated visualizations Unlock the power of Python with Copilot. #AI #Excel
0:33

Microsoft 365 Copilot in Excel with Python, now in preview, allows you to: ➡️ Perform advanced data analysis ➡️ Create sophisticated visualizations Unlock the power of Python with Copilot. #AI #Excel

Microsoft 365

100,591 views • 1 year ago

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)
0:30

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)

Excel Basement

228,343 views • 3 years ago

From rough ideas to quality work. OpenAl's GPT-5.6 is rolling out across Microsoft 365 Copilot in Word, Excel, PowerPoint, Chat, and Copilot Cowork. Optimized with OpenAl for knowledge work, GPT-5.6 is the preferred model for Microsoft 365 Copilot.
0:24

From rough ideas to quality work. OpenAl's GPT-5.6 is rolling out across Microsoft 365 Copilot in Word, Excel, PowerPoint, Chat, and Copilot Cowork. Optimized with OpenAl for knowledge work, GPT-5.6 is the preferred model for Microsoft 365 Copilot.

Microsoft 365

35,353 views • 1 month ago

How to Clean Excel Data in 1 click!
0:56

How to Clean Excel Data in 1 click!

Mani Kandan

25,880 views • 5 months ago

How to extract the Best and Worst scores in Excel! #tutorial 🗂️ Don’t forget to save this post! #excel #exceltips #exceltricks #googlesheets #spreadsheets #corporate #accounting #finance #workhacks #tutorials
0:47

How to extract the Best and Worst scores in Excel! #tutorial 🗂️ Don’t forget to save this post! #excel #exceltips #exceltricks #googlesheets #spreadsheets #corporate #accounting #finance #workhacks #tutorials

CheatSheets

14,770 views • 1 year ago

Bittensor $TAO Top 10?! 🤯 $HYPE is the #1 Perp DEX Layer 1 that deserves to be in the top 10. ✅ $ZEC is the #1 Privacy Layer 1 that deserves to be in the top 10. ✅ $TAO as the #1 AI Layer 1 that WILL be in the top 10. ☑️ Do you agree?👇Openτensor Foundaτion
0:23

Bittensor $TAO Top 10?! 🤯 $HYPE is the #1 Perp DEX Layer 1 that deserves to be in the top 10. ✅ $ZEC is the #1 Privacy Layer 1 that deserves to be in the top 10. ✅ $TAO as the #1 AI Layer 1 that WILL be in the top 10. ☑️ Do you agree?👇Openτensor Foundaτion

Finance Freeman 🇺🇸

11,117 views • 2 months ago

Only 1% know how to do this in Excel 🤯 Follow Miss Excel for more Excel & AI tips 💚 #excel #exceltips #corporate #workhacks
1:30

Only 1% know how to do this in Excel 🤯 Follow Miss Excel for more Excel & AI tips 💚 #excel #exceltips #corporate #workhacks

Miss Excel

16,276 views • 7 months ago

Detroit Tigers TOP prospect Max Clark on Kevin McGonigle “He’s a Killer” Max Clark is 1-0 against the Guardians in his career! 🐅📈
0:48

Detroit Tigers TOP prospect Max Clark on Kevin McGonigle “He’s a Killer” Max Clark is 1-0 against the Guardians in his career! 🐅📈

Woodward Sports Network

45,646 views • 1 day ago

Now that Wano is over, Here is Top 10 most beautiful sequence in One Piece !! 1. Luffy's Dream !
1:56

Now that Wano is over, Here is Top 10 most beautiful sequence in One Piece !! 1. Luffy's Dream !

Goofy D Luffy

487,127 views • 2 years ago

How to Exclude the Hidden Rows Data & Errors to Get the Total? in Microsoft #Excel | SUM vs. SUBTOTAL vs. AGGREGATE =AGGREGATE(9,7,C6:C14)
0:30

How to Exclude the Hidden Rows Data & Errors to Get the Total? in Microsoft #Excel | SUM vs. SUBTOTAL vs. AGGREGATE =AGGREGATE(9,7,C6:C14)

Excel Basement

151,345 views • 3 years ago

A moment of candour about the mood of the electorate and how hard it is in government now to be liked by voters - from Stephen Kinnock tonight on C4 News
1:23

A moment of candour about the mood of the electorate and how hard it is in government now to be liked by voters - from Stephen Kinnock tonight on C4 News

Krishnan Guru-Murthy

15,886 views • 3 months ago

How OpenAI made Codex The full episode with Alexander Embiricos is now live: Timestamps 0:00:00 Intro: Meet the Codex Team 0:00:21 Origin Story of Codex 0:15:03 How Users Are Adopting Codex: Surprising Patterns 0:36:38 Is AI Eating Software Engineering? 1:00:05 Building a Startup in the Age of AI Agents 1:07:58 Why Some Students Excel with AI Tools 1:10:56 Hiring at OpenAI: What Stands Out
1:27:08

How OpenAI made Codex The full episode with Alexander Embiricos is now live: Timestamps 0:00:00 Intro: Meet the Codex Team 0:00:21 Origin Story of Codex 0:15:03 How Users Are Adopting Codex: Surprising Patterns 0:36:38 Is AI Eating Software Engineering? 1:00:05 Building a Startup in the Age of AI Agents 1:07:58 Why Some Students Excel with AI Tools 1:10:56 Hiring at OpenAI: What Stands Out

Anjney Midha

31,764 views • 11 months ago

How to be in the top 1% in 21 seconds
0:21

How to be in the top 1% in 21 seconds

Mindset Machine 

177,136 views • 3 months ago