Find the middle day of the year
Yesterday (2nd July) was the exact middle point of 2022, so today (3rd July) is the first day of the year’s second half. π―π¬ It’s common knowledge that there are 365 days in a year (except leap years). As 365…
Concatenation Examples
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…
Wildcards in XLOOKUP
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…
SUBTOTAL Examples
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.
XLOOKUP Case Sensitivity
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…
Data Types in Excel
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….
End of content
End of content