CONCATENATE in Excel
To join text and/or numbers together using Excel’s CONCATENATE / CONCAT function. An example is shown how to generate a a set of SUM(CASE WHEN) SQL statements.
To join text and/or numbers together using Excel’s CONCATENATE / CONCAT function. An example is shown how to generate a a set of SUM(CASE WHEN) SQL statements.
Look up values in a table, using Excel’s VLOOKUP with the CONCATENATE function to combine values in multiple cells for the lookup. For example, convert a long format data table to a wide format data table.
How to return an array of non-adjacent cells in Excel.
How to use Excel’s RANDBETWEEN function to generate random numbers between two values. A short video shows how to turn the values from dynamic to static.
To test IF a value matches a condition, and return one result if TRUE, and another if FALSE.
How to use the VLOOKUP function in Excel
Use functions CHOOSE and RIGHT to create an array of values which includes mixed data types, to feed a LINEST calculation