Sorry sir,

For not given the complete information.
here is the example:

john 15000
pai 2000
john 15000
maria 58000
pai 2000
paul 5000
maria 58000

I want the result

john 15000
pai 2000
maria 58000
paul 5000

Thanks in Advance
Gord Dibben wrote:
Not sure what you mean by "merged the same into one".

Maybe you just want one each of all duplicates?

Try DataFilterAdvanced Filter.

Check "unique records" and "copy to another location".

Gord Dibben MS Excel MVP

Dear sir,

[quoted text clipped - 7 lines]

hardeep Kanwar(pai_kanwar @ yahoo.com)

--
Message posted via http://www.officekb.com