Tag: unique

  • Excel: Looking up data

    This time, I show you how I look up data in a table using the XLOOKUP function.

  • Excel: Finding unique values

    In complex datasets, finding the unique values can sometimes be a bit of a challenge. While you can often simply remove duplicates, if you intend to create a lookup-table, that isn’t an option, and you need to do it differently. Enter the UNIQUE-function. For this example, assume that you want all unique entries in column…