How To Concatenate A Range With A Delimiter

How To Concatenate A Range With A Delimiter

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...
How To Quickly Delete Blank Rows In Your Data

How To Quickly Delete Blank Rows In Your Data

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...
How To Use VLOOKUP With Multiple Lookup Criteria

How To Use VLOOKUP With Multiple Lookup Criteria

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...