It sounds like you want to use a pivot table. Hightlight your table, click
data - Pivot Table... and go through the steps. Drop your column with
duplicate data into the "Drop Row Fields Here" section. This should remove
duplicates and allow you to sum, count, average... the other columns

"pai_kanwar" wrote:

Dear sir,

I have an sheet which has 15000 data. In which some data is same and i have
to merged the same into one.

Is any way to find the same data because it take many hours to find one by
one

Thanks in advance

hardeep Kanwar(pai_kanwar @ yahoo.com)