Separating Unique Values & Duplicate Values

Maybe I can’t help you (enough) with your problem, but:

You get better result on your question if you add a small excel file, without confidential information.

Please also add the expected results manualy in your file.

Hi Gemini,

You need to have at least excel 2013. you can follow these steps to have unique values
Filter for unique values

Select the range of cells, or make sure the active cell is in a table.

On the Data tab, in the Sort & Filter group, click Advanced.

The Sort & Filter group on the Data tab

In the Advanced Filter dialog box, do one of the following:

To filter the range of cells or table in place, click Filter the list, in-place.

To copy the results of the filter to another location, do the following:

Click Copy to another location.

In the Copy to box, enter a cell reference.

Alternatively, click Collapse Dialog Button image to temporarily hide the dialog box, select a cell on the worksheet, and then press Expand Dialog Button image .

Select the Unique records only check box, and click OK.

The unique values from the selected range are copied to the new location. The original data is not affected.

More info you can find here
https://support.office.com/en-us/art...5-ca507915b704

One way

Please Login or Register  to view this content.