Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

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 Aufrufe • vor 2 Jahren •via X (Twitter)

#EXCEL
LIVE

Anya Rossi• Live Now

Private livecam show

1 Kommentare

Profilbild von CrispEXCEL Training & Consulting
CrispEXCEL Training & Consultingvor 2 Jahren

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

Ähnliche 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 Aufrufe • vor 3 Jahren

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 Aufrufe • vor 2 Jahren

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

97,983 Aufrufe • vor 2 Jahren

📊 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

17,928 Aufrufe • vor 1 Monat

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 Aufrufe • vor 2 Jahren

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 Aufrufe • vor 2 Jahren

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 Aufrufe • vor 1 Jahr

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 Aufrufe • vor 3 Monaten

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 Aufrufe • vor 3 Jahren

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,002 Aufrufe • vor 18 Tagen

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

How to Clean Excel Data in 1 click!

Mani Kandan

25,880 Aufrufe • vor 5 Monaten

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 Aufrufe • vor 1 Jahr

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 Aufrufe • vor 1 Monat

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 Aufrufe • vor 6 Monaten

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 Aufrufe • vor 2 Jahren

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 Aufrufe • vor 3 Jahren

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 Aufrufe • vor 3 Monaten

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 Aufrufe • vor 10 Monaten

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 Aufrufe • vor 3 Monaten

Chances of >Becoming a sperm: 1 in 10⁸ >Winning the sperm race (on top of that): 1 in 10¹⁶ >Actually getting born: 10¹⁶ × 10⁵ = 1 in 10²¹ >Being born human: 10²¹ × 10¹⁴ = 1 in 10³⁵ >Being physically & mentally fit: 10³⁵ × 10² = 1 in 10³⁷ >Getting access to education: 10³⁷ × 10⁰․⁵ = 1 in 10³⁷․⁵ >Affording laptop & internet: 10³⁷․⁵ × 10⁰․³ = 1 in 10³⁷․⁸ Image being 1 in 10³⁷․⁸ and still deciding to doom scroll.
1:30

Chances of >Becoming a sperm: 1 in 10⁸ >Winning the sperm race (on top of that): 1 in 10¹⁶ >Actually getting born: 10¹⁶ × 10⁵ = 1 in 10²¹ >Being born human: 10²¹ × 10¹⁴ = 1 in 10³⁵ >Being physically & mentally fit: 10³⁵ × 10² = 1 in 10³⁷ >Getting access to education: 10³⁷ × 10⁰․⁵ = 1 in 10³⁷․⁵ >Affording laptop & internet: 10³⁷․⁵ × 10⁰․³ = 1 in 10³⁷․⁸ Image being 1 in 10³⁷․⁸ and still deciding to doom scroll.

Dikshit Jain

138,597 Aufrufe • vor 5 Monaten