MERGED CELLS

[pai_kanwar]

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)

 

[Sean Timmons]

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

 

[Gord Dibben]

Not sure what you mean by "merged the same into one".

Maybe you just want one each of all duplicates?

Try Data>Filter>Advanced Filter.

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


Gord Dibben MS Excel MVP

 

[pai_kanwar via OfficeKB.com]

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

Not sure what you mean by "merged the same into one".

Maybe you just want one each of all duplicates?

Try Data>Filter>Advanced 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)

 

[Gord Dibben]

Follow the instructions for Advanced Filter posted in my first reply.

You will get your example result.


Gord

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

Not sure what you mean by "merged the same into one".

Maybe you just want one each of all duplicates?

Try Data>Filter>Advanced 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)