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...

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...

Rank & Sort Column Values, Ignoring Error Values

  Rank & Sort Numbers in a Column, Ignoring Error Values     Rank & Sort Column Numbers, Skipping Error Values    Column B: Ranks column A values, Ignoring Error values, in Descending Order (high to low). Column A contains numbers, and also error values (#N/A, #DIV/0!, etc), in random order. Enter Array formula (Ctrl+Shift+Enter) in cell...

Split Values into Multiple Equal Groups

  Split Values into Multiple Equal Groups / Ranks     Assign Column Values into Groups, with Group 1 having Largest Values & Group 5 Lowest Values    Column Values are divided equally between Groups, each group is ranked as per column values, Group 1 having Largest Values & Group 5 Lowest Values.   Column...

Count Uniques Appearing in Only One or in Both Columns

  Count Uniques appearing in BOTH Columns or in 1 Column and NOT in Other     Count Uniques: (i) which appear in BOTH Columns; (ii) which appear in 1 Column and NOT in the Other Column    Each Student (column A) has Multiple Subjects in Semester 1  (column B) and in Semester 2 (Column C)....

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...

Scroll to top