Uploaded July 2023 | Updated November 2026, 3 hours ago
π₯ Need to ace your Excel interviews? Get Excel School π chandoo.org/wp/excel-school-program
~
Here is a tricky Excel interview question. How do you figure out who our loyal customers are?
In this video, let me show you how to answer such tricky, hard interview questions using Excel functions.
We are going to use functions like FILTER, UNIQUE, MINIFS etc. to solve the problem.
β± In this video:
=============
0:00 - The hard Excel interview questions
0:40 - Calculating the next order date & gap to next order
3:04 - First question: How many customer place repeat order in 7 days and who are they?
4:06 - Second question: Of the customers who ordered in April 2023, who placed a repeat order in 2 weeks?
7:25 - How to solve questions like this using Excel?
πSample file & answers:
=====================
Check the problem file & answers here - chandoo.org/wp/wp-content/uploads/2023/07/interview-question-loyal-customers-.xlsx
πΊ WATCH NEXT:
===============
Beginner to PRO - Advanced Excel Class - youtu.be/v2oNWja7M2E
How to clean, analyze and present data - youtu.be/H6k28jhclwI
15 Advanced Excel Formulas - youtu.be/B5hayFelHDU
Top 10 Data Analyst Interview Questions - youtu.be/MX6Ee_ubE1s
π©βπ» Excel School Program - chandoo.org/wp/excel-school-program
~
#excelinterviewquestions #excel
π₯ Need to ace your Excel interviews? Get Excel School π chandoo.org/wp/excel-school-program
~
Here is a tricky Excel interview question. How do you figure out who our loyal customers are?
In this video, let me show you how to answer such tricky, hard interview questions using Excel functions.
We are going to use functions like FILTER, UNIQUE, MINIFS etc. to solve the problem.
β± In this video:
=============
0:00 - The hard Excel interview questions
0:40 - Calculating the next order date & gap to next order
3:04 - First question: How many customer place repeat order in 7 days and who are they?
4:06 - Second question: Of the customers who ordered in April 2023, who placed a repeat order in 2 weeks?
7:25 - How to solve questions like this using Excel?
πSample file & answers:
=====================
Check the problem file & answers here - chandoo.org/wp/wp-content/uploads/2023/07/interview-question-loyal-customers-.xlsx
πΊ WATCH NEXT:
===============
Beginner to PRO - Advanced Excel Class - youtu.be/v2oNWja7M2E
How to clean, analyze and present data - youtu.be/H6k28jhclwI
15 Advanced Excel Formulas - youtu.be/B5hayFelHDU
Top 10 Data Analyst Interview Questions - youtu.be/MX6Ee_ubE1s
π©βπ» Excel School Program - chandoo.org/wp/excel-school-program
~
#excelinterviewquestions #excel







![Excel for Managers [FREE Masterclass]
Do you work as a manager and use Excel? Then this live stream is for you. In this informative, useful and incredibly time-saving session, learn the most impactful Excel concepts & tricks that matter to you.
π Sample file: https://chandoo.org/wp/wp-content/uploads/2025/03/sample-file-done.xlsx
#excelformanagers #excel Excel for Managers [FREE Masterclass]](https://i.ytimg.com/vi/elbXQRARrhw/mqdefault.jpg)


