Formula Forensics 025. Count Unique Values in a Range
Need to count how many unique values occur in a range?
Learn how to do this and how the formula works right here.
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.
How to make a Spoke Chart
Have you ever wanted to make your own Custom Chart type ?
MarnieB was asked by her boss to make a Spoke Chart !
This post will explain how you can make a custom Excel Spoke Chart and introduce you to techniques that can be used to make other custom chart types.
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 ?
Chandoo Visits Perth Australia
Chandoo arrives in Perth, Australia.
Catchup with Chandoo in Perth
Do you want to catchup with Chandoo (and Hui) for a Sundowner in Perth ?
Read here for details.