What are the most mind blowing Excel formulas?

[Felipe Costa Gualberto]

Hello! My name is Felipe and I'm an Excel MVP from Brazil.

This forum is definitely one of the forums with the best Excel formula lovers in the internet.

I'm going to attend a seminar and the topic of my presentation will be "Fórmulas Esotéricas do Excel" (Esoteric Excel Formulas in portuguese). It will be held in São Paulo - Brazil, January 20, and right now I'm searching some examples from formula experts and forums, and I want to credit everyone correctly.

If you have some ideas, links and interesting Excel formulas, I'd love to know.
What are the most difficult problems formulas actually can solve? I want to blow the mind of the participants with things they didn't dream Excel could do with formulas.
A good reference blog is: https://excelxor.com/blog/

Thanks for your time!

 

[shrivallabha]

Welcome to Chandoo Org forums.

Take a look at the Excel Challenges Section. There you will find some interesting discussions for sure. They all are formula only (and strictly no VBA).

Wish you good luck with your seminar.

 

[NARAYANK991]

Hi ,

See this thread ; Apollo Huang is , unfortunately , more prolific in Chinese.

https://www.mrexcel.com/forum/excel-questions/154723-formula-challenge-iv-who-winner.html

Narayan