Monthly Archives: December 2022

Microsoft Excel – XLOOKUP using more than one column as the lookup value

Posted on December 21, 2022 by jdonbavand

Sometimes you need a combination of columns when trying to look up values in another data set. In the example below I need to find whether or not there are any restrictions as to the minimum number of nights stay … Continue reading →

Posted in Excel 365, Microsoft Excel | Tagged , | Leave a comment

Microsoft Excel – show each 15 minutes

Posted on December 14, 2022 by jdonbavand

I was asked recently whether I could create a column showing every 15 minutes from 8 am to 6 pm. This is actually quite straightforward. In the first cell to be included, type 08:00 and in the next cell down … Continue reading →

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

Microsoft Excel – TEXTAFTER for names like de Silva

Posted on December 12, 2022 by jdonbavand

If you have names all in one column and want to split into two columns that is relatively easy using Data – Text to Columns or using Flash Fill or the more recent TEXTSPLIT function. However, there is a problem … Continue reading →

Posted in Excel 365, Microsoft Excel | Tagged , , , | Leave a comment