Excel Basement's banner

Excel Basement

@ExcelBasement • 33,516 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,181 次观看 • 3 年前

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)

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)

228,343 次观看 • 3 年前

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

How to Get Total Number of Days in a month from list of Dates in Microsoft #Excel ? =DAY(EOMONTH(B5,0))

How to Get Total Number of Days in a month from list of Dates in Microsoft #Excel ? =DAY(EOMONTH(B5,0))

187,525 次观看 • 3 年前

How to Split Text with Multiple Delimiters in Microsoft #Excel | TEXTSPLIT Function

How to Split Text with Multiple Delimiters in Microsoft #Excel | TEXTSPLIT Function

173,555 次观看 • 3 年前

$Remove Unnecessary Spaces Like a PRO in Microsoft Word | Find & Replace with Wildcards | Find ( ){2,} and Replace with \1 enable Wildcards and Replace All$

Remove Unnecessary Spaces Like a PRO in Microsoft Word | Find & Replace with Wildcards | Find ( ){2,} and Replace with \1 enable Wildcards and Replace All

161,699 次观看 • 3 年前

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)

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)

151,345 次观看 • 3 年前

NESTED IF vs. VLOOKUP / XLOOKUP in Microsoft #Excel

NESTED IF vs. VLOOKUP / XLOOKUP in Microsoft #Excel

116,246 次观看 • 3 年前

Visual Filtering in Microsoft #Excel 1. Developer Tab > Insert > Active X Controls > Text Box > Properties > Linked Cell 2. Home Tab > Conditional Formatting > New Rule | =AND($C$3<>"",COUNTIF(B6,"*"&$C$3&"*")>0)

Visual Filtering in Microsoft #Excel 1. Developer Tab > Insert > Active X Controls > Text Box > Properties > Linked Cell 2. Home Tab > Conditional Formatting > New Rule | =AND($C$3<>"",COUNTIF(B6,""&$C$3&"")>0)

109,452 次观看 • 3 年前

SUM Techniques in Microsoft #Excel WhatsApp for MS Excel Course +923323339235

SUM Techniques in Microsoft #Excel WhatsApp for MS Excel Course +923323339235

89,709 次观看 • 2 年前

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

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

Create a Dynamic Serial Number which Adjusts Hidden Rows / Delete Values in Microsoft #Excel | =IF(B5<>"",SUBTOTAL(103,$B$5:B5),"")

Create a Dynamic Serial Number which Adjusts Hidden Rows / Delete Values in Microsoft #Excel | =IF(B5<>"",SUBTOTAL(103,$B$5:B5),"")

53,782 次观看 • 3 年前

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

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 次观看 • 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),{",","&"}))

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

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

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

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

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