How to filter unique data from a Column having multiple duplicate values.?

Shashi Yadav

I have column with various duplicate values e.g. Duplicate Transaction ID, Duplicate name in Column

I want to segregate unique records from that column and display in another sheet/column

please guide how to do so ?

Lucas Rayala

Hi @Shashi Yadav -- when you say unique record, are you saying you want to look at a list like this:

A

B

D

A

B

and get the unique values "A, B, D"? If that's what you want, then you can use the DISTINCT function. Here's a link to an article about the DISTINCT function:

DISTINCT Function | Smartsheet Learning Center

I hope this helps -- if not, you may want to include some screenshots to help us understand this ask specifically.