TechRepublic

How to use the UNIQUE() function to return a count of unique values in Excel

How to use the UNIQUE() function to return a count of unique values in Excel Your email has been sent The TechRepublic article How to create a sorted unique list in an Excel spreadsheet shows you how ...
TechRepublic

How to use the newish XLOOKUP() dynamic array function in Excel

Microsoft Excel’s dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP(). Microsoft Excel’s lookup functions are powerful but often misunderstood because they have a few ...