Have you ever wanted to find the newest/latest of all the different categories in a data set? For instance the latest sale by each sales person, the last registration by a person - and generate a table of these records.

I recently answered a post on this and thought I would drop it in here.

It is easy enough to round (nearest, up or down) to a specified number of decimal places, but what if you want to round to the nearest half? This is not something "standard" in functions provided, so a combination of other things are required.