Video yükleniyor...

Video Yüklenemedi

Ana Sayfaya Dön

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 görüntüleme • 2 yıl önce •via X (Twitter)

#EXCEL
LIVE

Anya Rossi• Live Now

Private livecam show

1 Yorum

CrispEXCEL Training & Consulting profil fotoğrafı
CrispEXCEL Training & Consulting2 yıl önce

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

Benzer Videolar

TEXTSPLIT in Excel‼️ #excel
0:30

TEXTSPLIT in Excel‼️ #excel

CheatSheets

23,265 görüntüleme • 1 yıl önce

TEXTSPLIT in Excel‼️ #excel
0:27

TEXTSPLIT in Excel‼️ #excel

CheatSheets

26,173 görüntüleme • 1 yıl önce

TEXTSPLIT in Excel‼️
0:30

TEXTSPLIT in Excel‼️

CheatSheets

35,989 görüntüleme • 1 yıl önce

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 görüntüleme • 2 yıl önce

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,866 görüntüleme • 2 yıl önce

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 görüntüleme • 2 yıl önce

1 IN A MILLION C4 TAG SHOT 🎯
0:42

1 IN A MILLION C4 TAG SHOT 🎯

Jinsu

53,377 görüntüleme • 1 ay önce

TEXTJOIN in Excel‼️ #excel
0:33

TEXTJOIN in Excel‼️ #excel

CheatSheets

17,438 görüntüleme • 1 yıl önce

วิธีใช้สูตร =TEXTJOIN สำหรับการรวมชื่อและนามสกุลเข้าด้วยกันใน Microsoft Excel ซึ่งแทนการ copy & paste ใหม่อีกรอบ เพื่อลดระยะเวลาทำงาน •. cr. excel.academmy
0:20

วิธีใช้สูตร =TEXTJOIN สำหรับการรวมชื่อและนามสกุลเข้าด้วยกันใน Microsoft Excel ซึ่งแทนการ copy & paste ใหม่อีกรอบ เพื่อลดระยะเวลาทำงาน •. cr. excel.academmy

• win 🏳️‍🌈

377,810 görüntüleme • 2 yıl önce

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 görüntüleme • 2 yıl önce

How to C4 piano window rappel 101
0:33

How to C4 piano window rappel 101

Jigsaw 🕊️

37,005 görüntüleme • 1 yıl önce

How to TextJoin Email Merge in Excel 🗂️ Don’t forget to save this post! #excel #exceltips #exceltricks #googlesheets #spreadsheets #corporate #accounting #finance #workhacks #tutorials
0:27

How to TextJoin Email Merge in Excel 🗂️ Don’t forget to save this post! #excel #exceltips #exceltricks #googlesheets #spreadsheets #corporate #accounting #finance #workhacks #tutorials

CheatSheets

10,957 görüntüleme • 10 ay önce

🚨 BREAKING: Microsoft is releasing Copilot for Microsoft 365: - Word - Powerpoint - Excel - Teams Here's the summary:
1:36

🚨 BREAKING: Microsoft is releasing Copilot for Microsoft 365: - Word - Powerpoint - Excel - Teams Here's the summary:

Pete

3,251,645 görüntüleme • 3 yıl önce

A Palestinian family was poisoned after accidentally ingesting C4 plastic explosive. The C4 was left in an envelope next to food.
1:06

A Palestinian family was poisoned after accidentally ingesting C4 plastic explosive. The C4 was left in an envelope next to food.

Sulaiman Ahmed

18,365 görüntüleme • 1 yıl önce

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,551 görüntüleme • 1 ay önce

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 görüntüleme • 1 yıl önce

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 görüntüleme • 3 yıl önce

The Callaway C4 Sledgehammer
0:47

The Callaway C4 Sledgehammer

PATINA RESEARCH

29,103 görüntüleme • 9 ay önce

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

How to Clean Excel Data in 1 click!

Mani Kandan

25,880 görüntüleme • 4 ay önce

dol-makyar is the first city of c4, I REPEAT, dol-makyar is the first city of c4!! #criticalrole
0:20

dol-makyar is the first city of c4, I REPEAT, dol-makyar is the first city of c4!! #criticalrole

Mia ✪ | fearne lover

27,627 görüntüleme • 9 ay önce