Category Archives: How to

Correct syntax for formulae

I think way back when, some highly-read source must have mistakenly advised people that to create a basic arithmetic formula, you needed the SUM, irrespective of the calculation being performed. So I often see formulae such as: =SUM(C7-C6) If you're … Continue reading →

Distances between places as the crow flies

Challenge: I have two the latitude and longitude of two places. I want to know the distance between them, as the crow flies. This took a lot of trial and error, made more tricky by having to also accommodate two … Continue reading →

Frequency count on a range of data

Challenge: I have thousands of rows of data, each containing multiple columns of piece of information. I want a frequency count of each piece of information that appears. I received some data the other day. In total, there were 1,000 … Continue reading →