Help

[panipat1990]

Dear Team,

I stuck a requirement.Kindly help me for solving this issue.

For this i am sharing a excel. where field indicate data and output i want this

Input

Adishwar Auto Diagnostics - PRE Owned Showroom

Adishwar Auto Diagnostics Pvt. Ltd. - Showroom

Showroom - Chandigarh

Output

Adishwar Auto Diagnostics

Adishwar Auto Diagnostics Pvt. Ltd.

Chandigarh

Kindly help me

[panipat1990]

1000 records in my field

[qlikview979]

as per my  knowledge

do like

If you have same names in this column use above code.

or

if you many new names in that column just insert that names in above condition and check and let me know.

[panipat1990]

Not the same name all are different name

[qlikview979]

Hi,

Remove Duplicates and Check in column how many unique names are there in column.

[Anil_Babu_Samineni]

May be this?