To do the useful thing, to say the courageous thing, to contemplate the beautiful thing: that is enough for one man’s life.

T. S. Eliot (1888-1965)

| | Posted in Quotes

# Its a FACT Jack

### Working out how many combinations are possible

Do you remember factorials in maths? That’s where you have, say four numbers, and you want to find out how many four number combinations you can make with those four numbers. In Maths you write it as 4!. The answer is 4 x 3 x 2 x 1 = 24.

September 11, 2015

A nice article about when and how to use hue – grades of colours – in charts.

Also the colours to avoid (hint: red and green).

An expert is a person who has made all the mistakes that can be made in a very narrow field.

Niels Bohr

| | Posted in Quotes

# Confirm Two Lists Match in Excel

### A single formula to check two lists

If you have two lists of numbers and you need to ensure they are identical there is a simple formula that can confirm they match.

27 Excel experts discuss Excel and its future with Business Intelligence.

Some great insights – worth a read.

# Summing every second row

### No array formula required

Let’s say you have a list of values that has a set sequence. In the list which starts in row 2 you want to add up every second entry. So you want to add up the entries in row 3, row 5, row 7 etc going down the sheet. The SUMPRODUCT function to the rescue yet again.

Unless you try to do something beyond what you have already mastered, you will never grow.

Ralph Waldo Emerson

| | Posted in Quotes

This site allows discussion on Data Visualisation topics.

You can post examples of good and bad visualisations for comment.

It takes less time to do a thing right, than it does to explain why you did it wrong.

| | Posted in Quotes

The happy people are those who are producing something; the bored people are those who are consuming much and producing nothing.

William Ralph Inge (1860-1954 )

| | Posted in Quotes

# Ordinals For Dates

### 1st,2nd,3rd,4th

If you want to place ordinals (st, nd, rd and th) after a number in a date. You can use the CHOOSE function to do this.