UNIQUE vs FILTER vs GETPIVOTDATA

Basic Classification Comparison

• Function Category 📊

  Primary classification of the Excel function based on its main purpose and usage domain, helps users quickly identify function types

  For all*

  • Database

    Excel functions for managing and analyzing database-like data

• Operation Type 🔧

  Fundamental type of operation or action that the Excel function performs on its inputs

  UNIQUE

  • Aggregation

    UNIQUE performs Aggregation operations. Excel functions for combining and summarizing data  Click to see all.

  FILTER

  • Manipulation

    FILTER performs Manipulation operations. Functions that modify and transform data in different ways

  GETPIVOTDATA

  • Retrieval

    GETPIVOTDATA performs Retrieval operations. Functions specialized in fetching data from various sources