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…
Table data is prone to being disorganised and clogging up worksheet space. Fortunately, you can create a multi-level hierarchy that breaks it down into groups so each is summarised separately. In Excel, these are called outlines, and the feature set…
Fast Data Load is a Power Query feature that makes loading queries faster by utilising additional CPU power and RAM. However, the drawback is Excel will become unresponsive for this duration, so it’s not recommended if you want to work…
Yesterday, I demonstrated how to use Excel data types to give cell content richer meaning. Issues like erroneous and missing data damage their credibility though, and it’s probably a big reason why Microsoft won’t be renewing their Wolfram license, which…
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….
Collaborating in an Excel workbook can be a disruptive experience. You’re working in the same worksheet as a colleague — they filter a table and suddenly it shrinks — interrupting the state you had it in and derailing your progress….
End of content
End of content
