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. (more…)
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. (more…)
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. (more…)
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. (more…)