Formula Forensics No. 029 SumIf with Inconsistent Column Layouts
How do we perform a Sumif on seemingly randomly spaced columns?
Today in Formula Forensics we look at a solution to do just that.
OFFSET formula – Explained
Today, lets learn OFFSET formula.
OFFSET formula gives us reference to a range, from a given starting point with given height and width in cells.
OFFSET formula syntax
OFFSET formula looks like this:
=OFFSET(starting point, rows to move, columns to move, height, width)
Starting point: This is a cell or range from which you want to offset
Rows & columns to move: How many rows & columns you want to move the starting point. Both of these can be positive, negative or zero. More on this below.
Height & width: This is the size of range you want to return. For ex. 4,3 would give you a range with 4 cells tall & 3 cells wide.
Read on…,
Making your dashboards interactive [Dashboard Essentials]
Everyone likes to be in control. Even my 2 year old daughter jumps with joy when she lays her hands on TV remote. She pushes the buttons and assumes it is working. It is another story that we rarely watch TV at home.
By adding an element of control, we can make our dashboard reports fun. Interactive elements like form controls, slicers etc. invite users to play with your dashboard, get involved and understand data by asking questions. That is why I recommend making dashboards interactive.
Today lets understand how you can make dashboards interactive.
Formula Forensics 024. Is this number a Prime Number ?
Is my number a Prime Number?
What is a Prime Number?
Today in Formula Forensics we answer both questions.
Formula Forensics 023. Count and Sum a Filtered List according to Criteria
Today at Formula Forensics, we look at how to Count and Sum data using Criteria on Filtered data sets.
Formula Forensics 022. Sum the Odd Numbers between 1 and 100
How can we Add Up the Odd numbers between 1 and 100 ?
Comprehensive Guide to VLOOKUP & Other Lookup Formulas
This week many Excel bloggers are celebrating VLOOKUP week. So I wanted to chip in and give you a comprehensive guide to VLOOKUP & Other lookup formulas. Read on …,
What is VLOOKUP Formula & how to use it?
I often tell my excel school students that learning VLOOKUP formulas will change your basic approach towards data. You will suddenly feel that you have discovered a superman cape in your attic. It is that awesome.