All articles with 'IsOdd()' Tag

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?

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

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.