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

Scroll to top