They say you learn something new every day.

Posts tagged ‘lookup’

Converting days to Numbers in Excel (15/11/2012)

I have a spreadsheet, with a list of days in it. I want to sort them by their order in the week (ie, Monday – Sunday), but Excel being Excel, it seems them as words and sorts them in alphabetical order.

I’ve had a bit of a play and found two functions I never really use, both of which can do this:



This is neat and  concise, but just returns the array element number.



 A bit longer, but allows you to return arbitrary values, not just the array position.


Tag Cloud