A while back, I showed you how I go about creating tables if average values using the UNIQUE and AVERAGEIF functions. While those tables are valuable in and of themselves, I use them to compare the pay an individual in my group gets with people in the same part of the organization.
Tag: unique
-
Excel: Looking up data
-
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.
(more…)