Comparing 2 Lists with a Twist
We love to compare. The instinct to compare leaves no one. Even my two year old twins compare their toys with each other (and fight).
It would make Excel hugely popular if Microsoft builds a handy data comparison tool right in to it. Alas, they have customizable ribbon, 3d effects & equation editor…
Since comparison is one of the main uses of Excel, we have written extensively about it here.
But there is always one more interesting comparison problem. Today, I want to share one such problem, based on a comment left by N-Man.
Formula Forensics No. 010 Count How Many Times a List of Values Occurs in a Range
Count How Many Times a List of Values Occurs in a Range
(or How Can I Simplify My Formula)
Today in Formula Forensics we look at how to count how many times a range of values occurs within a Range of cells and in the process simplify a very nasty formula.
Formula Forensics. No 007 – Sumproduct
One of the most asked questions within the posts and Forums at Chandoo.org is, How Does Sumproduct work ?
Today in Formula Forensics we take at look at just that with a few worked examples.
Formula Forensics 006. Palindromes
Palindrome: – A palindrome is a word, phrase, number, or other sequence of units that can be read the same way in either direction, with general allowances for adjustments to punctuation and word dividers (“Wikipedia”).
This week in Formula Forensics we’re having a look at determining if a cell contains a palindrome.
Formula Forensics No.004 – Fred’s Problem
.
.
.
.
.
.
.
This is the Forth post in Chandoo’s, Formula Forensics series.
Last week Luke showed us how to extract a sorted list according to a criteria from a larger list
and he analysed a formula to solve this problem
This week we look at Fred’s Problem…
How do I simplify a very long formula?
Christmas Gift Shopping List Template – Set budget, track your gifts using Excel
Last year, Steven shared a beautiful Christmas Gift List template with all of us. It is packed with lots of Excel goodness. Just a few days ago, he emailed me another copy of his file with some improvements. So if you are planning for Christmas shopping and want a handy tracker, you don’t want to miss this.
Sum of Values Between 2 Dates [Excel Formulas]
Lets just say, you run a nice little orange shop called, “Joe’s Awesome Oranges“. And being an Excel buff, you record the daily sales in to a workbook, in this format. After recording the sales for a couple of months, you got a refreshing idea, why not analyze the sales between any given 2 dates? […]