Category: Excel Formula & Functions

5 Types of Graphs to Create with REPT function

January 20, 2021

Only a few Excel users know about that we can create graphs with REPT function. Most people use the REPT function simply to repeat characters but the REPT function actually does much more than that. Some people think the REPT

How to Show Zeros as Blank Cells Practice workbook

How to Show Zeros as Blank Cells In Excel

January 12, 2021

Background Zeros are almost inevitable in a workbook. Sometimes you may change the appearance of the zero. Do you have the following ask? Display zero as blank cells Show zero as dash Hide zero without actually deleting zero In this

How to Generate Random Variables in Excel

January 8, 2021

Generating random numbers is easy with Excel! Learn about generating uniform and normal random numbers in Excel to aid your business analysis!

How to Sum Intersections of Multiple Ranges (Excel)

January 4, 2021

Background Sometimes we have to sum the intersections of multiple ranges. Can you think of a formula? Using INDEX MATCH? INDIRECT? And nested IF function? I go through exactly the same thought process until I meet Intersection operator. Don’t panic

How to Get Unique Values Without Unique function?

December 23, 2020

I will show you how to get unique values without unique function, by a standard formula or an array formula. Here is the perfect substitute for Unique.