Sorting in Word

Sorting in Word

What do you mean, Sorting in Word – that’s Excel, surely? Normally, I’d agree with you – we use Excel for “Number crunching”, working with lists, etc and we use Word for writing articles or letters – or even Blog posts – but occasionally, it...
Dealing with Errors in Lookups

Dealing with Errors in Lookups

The #N/A Error If we use the VLOOKUP Function to match between two sets of data – then occasionally, Excel will return an #N/A error where it can’t find the value in one list in the other one In this example, we have two lists of employee data where in the...

Pin It on Pinterest