Monthly Archives: August 2017

Microsoft Excel – comparing two columns using conditional formatting

Due to data entry issues, a client had instances where she had the same information for some records in both the Address2 and the Town column. She wanted a quick way of seeing where this was happening. Information stored in … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – VLOOKUP with prices and Exchange rates

If you have a spreadsheet of items in different currencies and are doing a VLOOKUP to find the prices, you may want to return the items in £ rather than in the mixture of currencies. In the example below, I … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , , , | Leave a comment

Microsoft Excel – showing column letters in a row of a worksheet

I was asked on a training course recently whether they could show column letters in a row in their Excel spreadsheet. There is probably more than one way to do this, but I did it with a combination of three … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment