duplicates

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

Datasets

Accepted answers

atcodedog05

Hi @VeronicaElse

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

Hope this helps : )

unique.yxmd

All comments

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

sample Alt.xlsx

atcodedog05

Hi @VeronicaElse

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

Hope this helps : )

unique.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703