How To Get Excel Unique Function Complete Guide

If your column has a header click the My data has headers tick box. The original column will now be replace with only the unique values. Click on the Remove Duplicates button.

Select a blank cell such as D2 enter the below formula into it and press the Ctrl Shift Enter keys simultaneously.

The Excel team recently announced new dynamic array formulas which can create unique lists sort and filter with a simple formula. IFERRORINDEXA2A10 MATCH0 COUNTIFB1B1A2A10 COUNTIFA2A10 A2A101 0 Regular unique values formula completed by pressing Enter. UNIQUE array by_col exactly_once. UNIQUE A1A10 To return unique values from the horizontal range A1E1 set the by_col argument to TRUE or 1.