duplicates

[VeronicaElse]

Hi, 

I have cases# that I am trying to check for duplicates and I  need to provide the line# associated with it as well if possible. It is in my TrackID column and unless I utilize Trim in excel, it wont pick them up with data cleansing tool or the Unique tool.

Plz help

thanks 

[atcodedog05]

Hi @VeronicaElse 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[VeronicaElse]

I dont know how much you need but here is the duplicates that are not being picked up with unique tool but with Excel -TRIM, then Duplicates it does.

If the output box can come out when using the Unique tool. I guess I would be fine with that plz.

thanks

[atcodedog05 · Accepted solution]

Hi @VeronicaElse 

is this what you are looking for if not please provide expected output.

Hope this helps : )

[atcodedog05]

Happy to help : ) @VeronicaElse 

Cheers and have a nice day!