Avoid repetition

[vinumv]

Dear All XL Gurus,

I have an xl file which I have taken output from one modelling software for steel structures. Here in the attached file u ca see profile names(like SPD24"X0.75", PD10.75"X0.5 etc) are repeated at many rows. Is there any formula to avoid the repitition?

Here I am attaching the file for your reference.

Waiting for the solution.

Have a nice day ahead.

Vinu

[protonLeah]

Have you considered Data, Advanced Filter, Unique...?

[Charles]

vinumv,

Not sure about a formula, but you can use an Advance Filter to copy the Unique data to another range.Or, you can use Vba code to do the same or even delete the dupes.

[vinumv]

Thanks a lot for your effort.

Have a great day.

[Charles]

vinumv,

Does this mean you are satisfied with the answers if so please show the thread as "Solved"
.