Finding Friday the 13th using Excel (and learning cool formulas along way)
Not that I have friggatriskaidekaphobia or anything. But since today is Friday & 13th, lets put our Excel skills to test and find out when the next Friday the 13th is going to be.
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. 005 – Zebras and Checker-Boards
Zebra Stripes and Checker Boards
This week in Formula Forensics I’m taking a break from Array Formulas to have a look at some Zebra Stripes and Checker Boards.
No, I haven’t gone crazy, although some may argue that point.
More specifically were going to take a look at, Zebra Stripes and Checker-Board Conditional Formatting.
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?
Formula Forensics No. 003 – Lukes Reward
Today we publish what is hopefully the First of many posts by guest author Luke M. it is also the Third post in the Formula Forensics series, which has now moved to a regular and new Thursday slot ?
Luke has taken up Hui’s and 3G’s challenge of explaining how the technique he regularly uses on the Chandoo.org Forums for extracting individual records out of a group.
Today Luke tells us how to extract a list of items from a larger list according to some criteria.
Formula Forensics No. 002 – Joyces Question
Formula Forensics # 002 – Joyces Question
This is the second post of a new regular weekly series at Chanoo.org, Formula Forensics, where we will examine how a formula works from the inside out with a worked example to help you understand its formation.
Last week we looked at Taruns problem and analysed a formula to solve his problem
This week we look at Joyce’s Problem…