by John MacDougall | Apr 20, 2016 | VBA
There are two ways of concatenating cells in Excel, either with the built-in CONCATENATE function or using &. But let’s say you wanted to concatenate a large number of cells into one value and have them separated by a delimiter character like a comma, this...
by John MacDougall | Apr 18, 2016 | Tips
How do you quickly and easily delete blank rows or columns in your data? This is a handy trick to know if you’ve ever come across a large set of data that for some reason or other has a lot of blank rows. Blank rows can make it more difficult to work with the...
by John MacDougall | Apr 17, 2016 | Formulas
Get The Completed Workbook Note: You will need to save the completed workbook somewhere on your computer for the functions to work. How do you get information about the current workbook such as the file name, file path and the current sheet name? The CELL function can...
by John MacDougall | Apr 16, 2016 | Formulas
Get The Completed Workbook VLOOKUP is one of the most useful functions in Excel, but after learning its use most people quickly realize some of its limitations. It only allows you to look up items to the right of a column with the criteria you’re looking up. It...
by John MacDougall | Apr 16, 2016 | Formulas
Get The Complete Workbook How do you use VLOOKUP with multiple lookup criteria? In its basic form, VLOOKUP can only look up data based on one criteria. To get around this, you could add in another helper column that concatenates the different criteria together and...