CONCAT and CONCATENATE are two functions that combine text values. The former first appeared in Excel 2016, whereas the latter has been around considerably longer and is still accessible for backwards compatibility purposes. Syntaxes Their syntaxes look similar, but do…
XLOOKUP is most commonly used for exact matches, but what if you don’t fully know what you’re searching for? Fortunately, it supports wildcards, which are characters that take the place of text so you can perform partial matches. This is…
Excel allows you to easily sum a column of numerical values via the ‘Total Row’ option in the Table Design tab. This generates a SUBTOTAL formula with numerous options including SUM (ignores hidden and unfiltered values) and COUNTA (counts non-empty cells). Awareness of these functions’ behaviour is crucial, as they handle hidden rows differently.
By default, XLOOKUP performs a case-insensitive lookup, meaning it finds the first match in a range irrespective of whether it’s uppercase, lowercase or mixed case. To circumvent this, it can be used in conjunction with EXACT. EXACT checks two text…
Traditionally, one cell meant one piece of data, but Excel data types add intelligent and richer meaning, creating a multidimensional view. Back in 2019, Stocks and Geography were the first categories added to the ribbon, appearing in the Data tab….
Press Ctrl + Shift + A after a function to display all its arguments. Then put a leading single quote to signify text. I often find this useful if I need to retrieve the arguments of a function I’m explaining….
End of content
End of content
