Excel Basement's banner

Excel Basement

@ExcelBasement • 33,833 subscribers

We provide services in the form of Training, Consultancy, Solutions, Coaching on Microsoft Office Products & Business Intelligence Tools.

Videos

Anya Rossi

sweetdream.ai

SweetDream.ai•Sponsored•Livecam

Watch Anya Live

Anya is streaming live right now! Join her private show and enjoy exclusive content.

Exclusive private shows

1.2k viewers online

Private Show

Join now for exclusive access

Free preview available • Premium content

Insert Logo from Image Function in Microsoft #Excel | =IMAGE(CONCAT("

495,014 görüntüleme • 3 yıl önce

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

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

211,435 görüntüleme • 3 yıl önce

NESTED IF vs. VLOOKUP / XLOOKUP in Microsoft #Excel

NESTED IF vs. VLOOKUP / XLOOKUP in Microsoft #Excel

113,824 görüntüleme • 2 yıl önce

Lookup & Return Multiple Values in Single Cell in #Excel (NO VBA | Easy Dynamic Array Formula) When the Lookup Values are Duplicates and Needs to Fetch Multiple Outputs | TEXTJOIN in Excel 2019 / 365 =TEXTJOIN(", ",TRUE,IF(A22=Data[Employees],Data[Skills],""))

Lookup & Return Multiple Values in Single Cell in #Excel (NO VBA | Easy Dynamic Array Formula) When the Lookup Values are Duplicates and Needs to Fetch Multiple Outputs | TEXTJOIN in Excel 2019 / 365 =TEXTJOIN(", ",TRUE,IF(A22=Data[Employees],Data[Skills],""))

87,769 görüntüleme • 3 yıl önce

Difference Between SWITCH & IFS Function in MS #Excel =SWITCH(Measure,B6,C6,B7,C7,B8,C8,"Not Found!") =IFERROR(IFS(Measure=B6,C6,Measure=B7,C7,Measure=B8,C8),"Not Found!") =XLOOKUP(Measure,B6:B8,C6:C8,"Not Found!") =FILTER(C6:C8,B6:B8=Measure,"Not Found!")

Difference Between SWITCH & IFS Function in MS #Excel =SWITCH(Measure,B6,C6,B7,C7,B8,C8,"Not Found!") =IFERROR(IFS(Measure=B6,C6,Measure=B7,C7,Measure=B8,C8),"Not Found!") =XLOOKUP(Measure,B6:B8,C6:C8,"Not Found!") =FILTER(C6:C8,B6:B8=Measure,"Not Found!")

76,177 görüntüleme • 3 yıl önce

Separate Names and Units Sold from Messy Data having Multiple Delimiters | TEXTSPLIT Function in #Excel 365 =TRIM(TEXTSPLIT(B5,"-",{",",";","/"}))

Separate Names and Units Sold from Messy Data having Multiple Delimiters | TEXTSPLIT Function in #Excel 365 =TRIM(TEXTSPLIT(B5,"-",{",",";","/"}))

46,808 görüntüleme • 3 yıl önce

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

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

25,565 görüntüleme • 2 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),{",","&"}))

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),{",","&"}))

23,102 görüntüleme • 2 yıl önce

Hide used items in Drop down List - Remove Previously used items in Microsoft #Excel Dropdown

Hide used items in Drop down List - Remove Previously used items in Microsoft #Excel Dropdown

27,334 görüntüleme • 3 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)

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)

20,409 görüntüleme • 2 yıl önce

Convert No of Months or Days into Different Formats in #Excel Example 1: =QUOTIENT(B5,12) & " Years "& MOD(B5,12) & " Months"

Convert No of Months or Days into Different Formats in #Excel Example 1: =QUOTIENT(B5,12) & " Years "& MOD(B5,12) & " Months"

19,609 görüntüleme • 2 yıl önce

Extract TEXT only from Cell in Microsoft #Excel 365 Version =TEXTJOIN(" ",,TEXTSPLIT(B5,TEXTSPLIT(B5,CHAR(SEQUENCE(,26,65)),,1,1),,1)) Thanks to Rick Rothstein (LINKEDIN) for Solution

Extract TEXT only from Cell in Microsoft #Excel 365 Version =TEXTJOIN(" ",,TEXTSPLIT(B5,TEXTSPLIT(B5,CHAR(SEQUENCE(,26,65)),,1,1),,1)) Thanks to Rick Rothstein (LINKEDIN) for Solution

14,474 görüntüleme • 2 yıl önce

How to Extract Numbers only with Comma Delimiter from a Cell in Microsoft #Excel 365 =TEXTJOIN(", ",,TEXTSPLIT(B5,TEXTSPLIT(B5,SEQUENCE(10,,0),,1),,1)) Thanks to Rick Rothstein for Solution

How to Extract Numbers only with Comma Delimiter from a Cell in Microsoft #Excel 365 =TEXTJOIN(", ",,TEXTSPLIT(B5,TEXTSPLIT(B5,SEQUENCE(10,,0),,1),,1)) Thanks to Rick Rothstein for Solution

11,193 görüntüleme • 2 yıl önce

Video: How to Lookup Picture in Excel 365? | Lookup Picture in Cell #Excel 365 Version with XLOOKUP

Video: How to Lookup Picture in Excel 365? | Lookup Picture in Cell #Excel 365 Version with XLOOKUP

11,460 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),"")

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),"")

10,623 görüntüleme • 2 yıl önce

Daha fazla içerik yok.