正在加载视频...

视频加载失败

返回首页

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 次观看 • 2 年前 •via X (Twitter)

#EXCEL
LIVE

Anya Rossi• Live Now

Private livecam show

1 条评论

CrispEXCEL Training & Consulting 的头像
CrispEXCEL Training & Consulting2 年前

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

相关视频

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 次观看 • 3 年前

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 次观看 • 2 年前

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 次观看 • 2 年前

📊 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 | AI Productivity

18,112 次观看 • 2 个月前

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 次观看 • 2 年前

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 次观看 • 2 年前

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).

Mas Bil 📊 📊

33,409 次观看 • 4 个月前

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 次观看 • 1 年前

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 次观看 • 3 年前

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,503 次观看 • 1 个月前

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

How to Clean Excel Data in 1 click!

Mani Kandan

25,880 次观看 • 6 个月前

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,148 次观看 • 2 个月前

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 次观看 • 7 个月前

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 次观看 • 12 天前

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 次观看 • 2 年前

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 次观看 • 3 年前

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 次观看 • 3 个月前

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 次观看 • 4 个月前