Extract a Sorted List of Unique values in a column

  Return Sorted Unique List of Values from Column having only Text or only Numbers     Sort Column values in Ascending / Descending Order, Retain Duplicates or Extract only Once (ie. Uniques)    Column F: Extracts Uniques & Sorts column E values in Ascending order – column E can have ONLY Numbers. Enter Array formula...

Unique List from Single Column, Skip Specific Values

  Extract Unique List from a Single Column (Multiple Occurrences Appear only Once) – Skip Specific Value(s)     Return Unique List of Values from a Single Column, skipping Specific Values   Column A values appear either once (Unique) or multiple times (Duplicate) – these are extracted to appear ONLY ONCE, Skipping Specified Value(s).   In...

Unique List Appearing in One Column and Not in Other

  Return Unique List of values which appear only in One Column and NOT the other – or Unique List from Both Columns     Return Unique List of Values from a Column which do not appear in the Other Column   Column D: Extract Unique List of values from column A (each column A value...

Extract Unique sub-strings of 1st 5 Characters from each column cell

  Extract Unique List from a Column: (i) Fixed Length of 1st 5 Characters of each cell string; or (ii) Variable Length of Characters in each cell Preceding the 1st “-” (Dash)     Extract a Unique List of Codes from column cells: (i) Fixed Length of 1st 5 Characters; (ii) Variable Number of Characters...

Extract Values which appear ONLY once, from a Column

  Extract Values which appear ONLY once (ie. Unique Values) from a Column     Only those values which appear ONCE in a Column are extracted.   Column A values appear either once (Unique) or multiple times (Duplicate) – only those values which appear ONCE are extracted in columns B;   Enter Non-Array formula in...

Scroll to top