Tuesday, 7 May 2013

Some useful data presentation functions



Here are two useful functions plus a light-hearted one...

The first is great for anyone dealing with manually-entered data which might be a little untidy. The TRIM function will remove any preceding or training spaces. You could create a new column after a column of data (for example, names or addresses) and enter the following formula: =TRIM(cell ref). For example if A1 contains " Hello ", and you enter =TRIM(A1), the result will be "Hello". This is a little step towards cleaner data.

You're probably familiar with using MAX and MIN to display the largest and smallest values in a list. But what if you want the third smallest? We can use SMALL to do this. Imagine D1:D5 contains 8, 5, 6, 1, 3 and you want to know the third smallest number. Use =SMALL(D1:D5,3) to show this.

A fun one to close: try entering =ROMAN(2012) into Excel and see what you get...

No comments:

Post a comment