5 WEIRD & CRAZY Excel formulas - FILTERXML, BASE, REPT and more...
Welcome to the strange and wonky world of Excel formulas. In this video check out my top 5 unusual Excel formulas.
We will look at:
1) Making secret code with BASE and DECIMAL formulas
2) Charts with REPT
3) Between with MEDIAN
4) Last word with FILTERXML
5) Unique count with COUNTIFS
Have you got any unusual tales to share? Please post them in the comments.
Sample file:
https://chandoo.org/wp/wp-content/uploads/2020/03/unusual-formulas.xlsx
More unusual Excel uses:
https://chandoo.org/wp/unusual-excel-uses/
#ExcelFormulas #UnusualExcelFormulas #WeirdExcelFormulas
Видео 5 WEIRD & CRAZY Excel formulas - FILTERXML, BASE, REPT and more... канала Chandoo
We will look at:
1) Making secret code with BASE and DECIMAL formulas
2) Charts with REPT
3) Between with MEDIAN
4) Last word with FILTERXML
5) Unique count with COUNTIFS
Have you got any unusual tales to share? Please post them in the comments.
Sample file:
https://chandoo.org/wp/wp-content/uploads/2020/03/unusual-formulas.xlsx
More unusual Excel uses:
https://chandoo.org/wp/unusual-excel-uses/
#ExcelFormulas #UnusualExcelFormulas #WeirdExcelFormulas
Видео 5 WEIRD & CRAZY Excel formulas - FILTERXML, BASE, REPT and more... канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
The *ONLY* 10 Excel keyboard shortcuts you need to masterLearn these top 10 Excel Formulas to be GREAT at your workGUESS what's HIDDEN in Excel? (Cool Trick)I no longer VLOOKUP(), I use this other function instead…10 unusual questions to expect in Data Analyst interviews in 2022Learn Macros in 7 Minutes (Microsoft Excel)VBA or Python - Which one should you learn first? // For data people10 Excel Formulas Make you Excel Expert | Excel FormulaBreaking News! We FINALLY get the Excel functions we've been Wanting!Excel FILTER Function to Return Non-Adjacent Columns in Any Order5 Excel Functions YOU NEED in 2021 & 20225 *Must have* Excel Conditional Formatting TricksTop 10 Excel Formulas & Functions - Tutorial 1 | (VLOOKUP, INDEX, MATCH, XLOOKUP)Consolidate & Clean Multiple Excel Sheets in One Pivot TableMy lookup results are all wrong!What the function - TEXTJOIN in Excel + 3 Advanced ExamplesHow to Calculate Hours Worked with Excel Power Query (& Properly Sum time)Excel VBA: The Little-known secrets of ByVal and ByRefhow to use 3D formula in Excel | Consolidate data from different worksheets