Combining 2 sheets into a 3rd and removing duplicate values

**Muttly** · 06-11-2007, 12:12 PM

I have 2 sheets with names in, some names between the 2 sheets are duplicates.

On a third sheet, can I copy the details from the other 2 sheets (that part I know) and get excel to remove the duplicates from the new sheet so I end up with a unique list?

Finally when I have the unique list made can I get excel to sort it in descending order automatically.

Thanks for your help.

**Flintstone** · 06-11-2007, 02:18 PM

Hello Muttly:

The range of names is divided into a single column for both sheets, this way you should'nt have to copy anything.

Matt

**Muttly** · 06-11-2007, 06:18 PM

Originally Posted by Flintstone

Hello Muttly:

The range of names is divided into a single column for both sheets, this way you should'nt have to copy anything.

Matt

Thanks Flintstone, that looks about right. I'll try implementing it to my own file tomorrow and hopefully it'll give the right result.

**Muttly** · 06-12-2007, 07:12 AM

Thanks Flintstone, that brings the data into the 3rd sheet in alphabetical order.

That does 90% of it.

The final step is to make the data sort in a different order automatically. Is this possible.

Basically I have included an excel file showing what I have after getting all the data sorted in alphabetical order in TB1 and then in TB2 shows what I want to get its basically sort descending on column L, L3 to L27 extending the sort to B3.

I know its very easy do manually but it'd be handier if it did it automatically.

See attached file for examples.

**Flintstone** · 06-15-2007, 03:16 PM

Muttly:

I’m confused when you say, “and then in TB2 shows what I want to get its basically sort descending on column L, L3 to L27 extending the sort to B3.” If you could expand on this it might help me to understand.

I’m guessing you want column L to be sorted in descending order automatically and then all the data to the left of it would sort accordingly to match, is this correct?

Matt