'Unique values' category


You are here: Excel » Unique values »

Subcategories

  • Range (1)

  • How to extract a case sensitive unique list from a column
    This article demonstrates a formula that extracts unique values from a column also considering upper and lower characters (case sensitive). […]
    Filter unique words from a range [UDF]
    This blog post describes how to create a list of unique words from a cell range. Unique words are all […]
    Create numbers based on numerical ranges
    The image above shows an array formula in cell B3 that calculates numbers based on the numerical ranges in cell […]
    List all unique distinct rows in a given month
    This article demonstrates a formula that extracts unique distinct records/rows for a given month specified in cell C2, see the […]
    Filter unique values from a cell range
    Unique values are values occurring only once in cell range. This is what I am going to demonstrate in this blog […]
    Filter unique values sorted from A to Z
    A unique value is a value that only exists once in a list. A unique distinct list contains all cell values […]
    Find min and max unique and duplicate numerical values
    Table of Contents Extract largest duplicate number Extract largest duplicate number - Excel 365 Extract smallest duplicate number Extract smallest […]
    Filter unique values and sort based on adjacent date
    The formula in cell F3 extracts unique values from column C, the formula in cell F3 extracts the corresponding dates […]
    Sum number based on corresponding unique value
    The formula in cell E14 adds a number from column C if the corresponding value in column B is unique […]
    Extract unique values from two columns
    I read an article Merging Lists To A List Of Distinct Values at CPearson. The article describes code that you […]
    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 categories

    FunctionsFormulasExcel TablesAdvanced FilterData ValidationDrop DownNamed RangesExcel SolverChartsConditonal FormattingPivot TablesVBAMacrosUDFsArchive