Get
Digital
Help
More
  • Home
  • Functions
    Functions A to Z Functions by category
  • Formulas
  • Features
    Excel Basics Excel Defined Table Advanced Filter Data Validation Drop-down lists Named Ranges Solver
  • Charts
  • Conditional formatting
  • Pivot table
  • VBA
    VBA Functions Methods Properties Statements Macros User defined functions Files & folders Checkboxes
  • Archive
    All articles Products
  • Contact
    About me Blogs I read
    Formula categories
    #
    2D
    3D
    365
    Address
    Advanced Filter
    Alternative
    And logic
    Autofilter
    Average
    Blank
    Calendar
    Case
    Character
    Column
    Combination
    Complex
    Concatenate
    Conditional formatting
    Count
    Countif
    Countifs
    Criteria
    Date
    Day
    Decimal
    Delete
    Digit
    Duplicates
    Dynamic
    Empty
    Equal
    Error
    Extend
    Extract
    Finance
    First
    Group
    Hour
    Hyperlink
    If
    Ifs
    Ignore
    Image
    Index
    Index match
    Intersection
    Lambda
    Large
    Letter
    Lookup
    Match
    Max
    Min
    Minute
    Month
    Multiply
    Negative
    New line
    Not equal
    Or logic
    Overlapping
    Partial
    Permut
    Random
    Rearrange
    Record
    Recursive
    Reference
    Relation
    Reverse
    Right
    Running total
    Schedule
    Second
    Sequence
    Shared
    Small
    Solver
    Sort
    Split
    String
    Substitute
    Subtotal
    Sum
    Sumif
    Sumifs
    Sumproduct
    Tab
    Table
    Team
    Text
    Time
    Unique
    Vlookup
    Week
    Year



'Unique values' category


Subcategories

  • Range (1)

    • test
    Working with unique values
    What's on this page Extract unique values from two columns - Excel 365 Extract unique values from two columns - […]
    test
    5 easy ways to extract Unique Distinct Values
    First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]

    Excel formula categories

    AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values

    Excel categories


    Home page
    Excel Functions
    Excel Formulas
    Excel Tables
    Advanced Filter
    Data Validation
    Drop Down List
    Named Ranges
    Excel Solver
    Charts
    Conditonal Formatting
    Pivot Tables
    VBA
    Macros
    UDFs
    Archive

    • Search website

    Privacy PolicyNo AI