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)
Monthly Archives: September 2015
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
An expert is a person who has made all the mistakes that can be made in a very narrow field.
Niels Bohr
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
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.
Henry Wadsworth Longfellow (1807-1882)
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 )
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.
A nice article about when and how to use hue – grades of colours – in charts.
Also the colours to avoid (hint: red and green).