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

sweetdream.ai

Watch Anya Live

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

Private Show

Join now for exclusive access

Free preview available • Premium content

495,014 views • 3 years ago

211,435 views • 3 years ago

113,824 views • 2 years ago

87,769 views • 3 years ago

76,177 views • 3 years ago

46,808 views • 3 years ago

25,565 views • 2 years ago

23,102 views • 2 years ago

27,334 views • 3 years ago

20,409 views • 2 years ago

19,609 views • 2 years ago

14,474 views • 2 years ago

11,193 views • 2 years ago

11,460 views • 2 years ago

10,623 views • 2 years ago

No more content to load

Live Cam

Excel Basement

Videos

Watch Anya Live

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

Extract First, Middle &amp; 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)

NESTED IF vs. VLOOKUP / XLOOKUP in Microsoft #Excel

Lookup &amp; 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],""))

Difference Between SWITCH &amp; 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!")

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

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

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

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

Extract First, Middle &amp; 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)

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

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

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

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

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

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)

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

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

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

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)

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