All articles with 'IsOdd()' Tag

Looking up when the data won’t co-operate (case study)

Published on Nov 4, 2014 in Excel Challenges, Excel Howtos
Looking up when the data won’t co-operate (case study)

Occasionally we deal with data that is so uncooperative that we might as well give up and go back to calculators & ledger books.

Recently I found myself in such a situation and learned something new.

Introducing … data that won’t play nice

Drum roll please. Here is a data-set that I got from somewhere.

The problem – build a lookup formula

And the problem. Oh, simple. Write a lookup formula to find how many customer walk-ins we have on any given day.

But how?

Continue »

Formula Forensics 022. Sum the Odd Numbers between 1 and 100

Published on May 24, 2012 in Formula Forensics, Huis, Posts by Hui
Formula Forensics 022. Sum the Odd Numbers between 1 and 100

How can we Add Up the Odd numbers between 1 and 100 ?

Continue »

Formula Forensics No. 005 – Zebras and Checker-Boards

Published on Dec 8, 2011 in Formula Forensics, Huis, Learn Excel, Posts by Hui
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.

Continue »