Filter for unique values

[balu7979]

I Have a names in excel a1 to a13, i want to Filter for unique values, after getting the unique values, i change the Name to correct format, when ever i change the 1st unique value, how to automatically change the duplicate Values.

Corret Name : Balu, Raju,
When Ever i Change a1 Ballu to Balu,
in all the a2,a3,a5,a6,a7,a8, values to change Balu autometically how
a1 Ballu
a2 ballu
a3 ballu
a4 rajuu
a5 ballu
a6 ballu
a7 ballu
a8 ballu
a9 rajuu
a10 rajuu

 

[FDibbins]

If you have applied the filter and have a list of names shown that you want to change, after changing the 1st 1, just copy down to the rest that are showing

 

[balu7979]

can u explain one again i little bit confusion, (1 by one Step)

 

[FDibbins]

You said you had already applied the filter, to get the list of names you want to change?

If so, while that filter is still applied, correct the 1st name, then just copy it down to all the other names you want to have changed. It will not affect the rows that are hidden by the filter