5 WEIRD & CRAZY Excel formulas - FILTERXML, BASE, REPT and more...

Share this & earn $10
Chandoo
Published at : 20 Jan 2021
10636 views
365
10

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
chandoochandoo.orgExcel

The Car that Will Not Die - Nitrous Nissan Sentra

The Car that Will Not Die - Nitrous Nissan Sentra

Aparaty - To jest noc (OFFICIAL VIDEO 2020)

Aparaty - To jest noc (OFFICIAL VIDEO 2020)

Introduction to Maven | Theory

Introduction to Maven | Theory

How I Knew I Was Pregnant BEFORE I Got My BFP! no morning sickness, sore boobs or craving symptoms!!

How I Knew I Was Pregnant BEFORE I Got My BFP! no morning sickness, sore boobs or craving symptoms!!

World Best And Rarest Collection 2020 🤯❤️ Jigs One Of The Richest Collection In India♥️🇮🇳

World Best And Rarest Collection 2020 🤯❤️ Jigs One Of The Richest Collection In India♥️🇮🇳

Definite and Indefinite Articles in the Newspaper.

Definite and Indefinite Articles in the Newspaper.

Effective study Hacks to focus on your study. Study with me. Nabila’s Amazing World.

Effective study Hacks to focus on your study. Study with me. Nabila’s Amazing World.

Fastest Sprint Speeds in Football 2021 ᴴᴰ

Fastest Sprint Speeds in Football 2021 ᴴᴰ

Specialised Imaging – Tracker2 – Projectile tracking system

Specialised Imaging – Tracker2 – Projectile tracking system

Dance As A Way Of Knowing: Interview With  Alva Noë

Dance As A Way Of Knowing: Interview With Alva Noë

Mini Bonus Hunt + New ELK slot Katmandu + More, Also Community BIG WINS!! & Shout Outs

Mini Bonus Hunt + New ELK slot Katmandu + More, Also Community BIG WINS!! & Shout Outs

Group Problem Solving Steps

Group Problem Solving Steps

Tristan da Cunha island-To The Point

Tristan da Cunha island-To The Point

Daryl Hall & John Oates - Some Things Are Better Left Unsaid (Official Video)

Daryl Hall & John Oates - Some Things Are Better Left Unsaid (Official Video)

Bullseye Contestants with Strange Throws

Bullseye Contestants with Strange Throws

Intro to Conditional Probability

Intro to Conditional Probability

Dr Tedros on the milestone of smallpox eradication and lessons learned for COVID-19 response

Dr Tedros on the milestone of smallpox eradication and lessons learned for COVID-19 response

Raury - Forbidden Knowledge (Official Audio) ft. Big K.R.I.T.

Raury - Forbidden Knowledge (Official Audio) ft. Big K.R.I.T.

Bean as an Extra | Classic Mr. Bean

Bean as an Extra | Classic Mr. Bean

I'll Buy WHATEVER You Can Spell!

I'll Buy WHATEVER You Can Spell!

How to acquire English naturally. Improve your English Speaking, Listening and Pronunciation.

How to acquire English naturally. Improve your English Speaking, Listening and Pronunciation.

Evaporation of perennial semi-arid woodland in south eastern Australia is adapted

Evaporation of perennial semi-arid woodland in south eastern Australia is adapted

An Iron Age Pit is Stuffed with 25 Victims of Human Sacrifice

An Iron Age Pit is Stuffed with 25 Victims of Human Sacrifice

Air Compressor Basics (compressor types)

Air Compressor Basics (compressor types)

Dropkick Murphys - Worker's Song (with lyrics)

Dropkick Murphys - Worker's Song (with lyrics)

RC Airplane Battle | Dude Perfect

RC Airplane Battle | Dude Perfect

Illustrator CC Tutorial | Graphic Design | Brochure Design

Illustrator CC Tutorial | Graphic Design | Brochure Design

1 Hour of Beautiful Relaxing Snow Falling in a Mountain Village

1 Hour of Beautiful Relaxing Snow Falling in a Mountain Village

Among Us - Bad Timing / Funny Moments #36

Among Us - Bad Timing / Funny Moments #36

GCN's Guide To Buying Your First Road Bike

GCN's Guide To Buying Your First Road Bike

ULTRA LOW DEFI ALTCOIN SOLVING TRILLION DOLLAR ISSUE!!

ULTRA LOW DEFI ALTCOIN SOLVING TRILLION DOLLAR ISSUE!!

Beautiful Home Decor DIYs That Will Inspire You || Glue Gun Crafts And Cement DIY Ideas

Beautiful Home Decor DIYs That Will Inspire You || Glue Gun Crafts And Cement DIY Ideas

The Funeral Cover Rip-Off | Carte Blanche | M-Net

The Funeral Cover Rip-Off | Carte Blanche | M-Net

পুর্তগাল বনাম বাংলাদেশ | কোন দেশ বেশি শক্তিশালী? Portugal Vs Bangladesh Military Comparison 2021|

পুর্তগাল বনাম বাংলাদেশ | কোন দেশ বেশি শক্তিশালী? Portugal Vs Bangladesh Military Comparison 2021|

Three Middle Hitter Double Quick Offensive System

Three Middle Hitter Double Quick Offensive System

iPhone 13 Pro - concept

iPhone 13 Pro - concept

Guyana - Land of many waters

Guyana - Land of many waters

How To Clear Cache and Cookies In Chrome [2019]

How To Clear Cache and Cookies In Chrome [2019]

Should You Persist Or Quit Pt 2! Are You Making This Mistake?!

Should You Persist Or Quit Pt 2! Are You Making This Mistake?!

Meet The First Machine Washable Rug

Meet The First Machine Washable Rug

The Funniest Golden Globes Acceptance Speeches Of The Past 25 Years | TODAY Original

The Funniest Golden Globes Acceptance Speeches Of The Past 25 Years | TODAY Original

[릴레이댄스] 던(DAWN) - 던디리던(Feat. Jessi) (4K)

[릴레이댄스] 던(DAWN) - 던디리던(Feat. Jessi) (4K)

Testing The Cheapest Tablet on Amazon

Testing The Cheapest Tablet on Amazon

Oceanator - I Would Find You [OFFICIAL MUSIC VIDEO]

Oceanator - I Would Find You [OFFICIAL MUSIC VIDEO]

AMC MOST RECENT INSTITUTIONAL OWNERSHIP! AMC Daily Update, News, & Analysis!

AMC MOST RECENT INSTITUTIONAL OWNERSHIP! AMC Daily Update, News, & Analysis!

A SATISFYING AFTER CHRISTMAS UNDECORATE & CLEAN WITH ME! WINTER STORM WARNING!  🌨

A SATISFYING AFTER CHRISTMAS UNDECORATE & CLEAN WITH ME! WINTER STORM WARNING! 🌨

Kodaline - High Hopes

Kodaline - High Hopes

CAPRICORN ♑️ HEART TO HEART 💕 Emotions are running high... an opportunity to mend a connection.

CAPRICORN ♑️ HEART TO HEART 💕 Emotions are running high... an opportunity to mend a connection.

Santana - Maria Maria ft. The Product G&B (Official Video)

Santana - Maria Maria ft. The Product G&B (Official Video)