Challenge for everyone - Sort a text list adding a count in the bottom of each group. :)

Hello everyone

I know you're all busy so i'll keep it as brief as possible, I have a challenge that i haven't been able to solve for a while besides doing it manually which i'm estimating would take a year at least. I've searched the net and this forum and came up empty. So what i'd like to do put all the make and models into a group with a total at the bottom and them sort them with the highest performer to the lowest performer

I.E from this:

Toyota Corolla
Toyota Corolla
Toyota Corolla
Toyota Corolla
Toyota Camry
Toyota Camry
Toyota Camry
Toyota Camry
Toyota Camry
Holden Astra
Holden Astra
Holden Astra
Holden Astra
Holden Astra
Holden Astra
Holden Astra

To:
Holden Astra
Holden Astra
Holden Astra
Holden Astra
Holden Astra
Holden Astra
Holden Astra
Total 7

Toyota Camry
Toyota Camry
Toyota Camry
Toyota Camry
Toyota Camry
Total 5

Toyota Corolla
Toyota Corolla
Toyota Corolla
Toyota Corolla
Total 4

Is this possible?

Also is there a way to sort and place into a new sheet from this
http://www.excelforum.com/attachment...9.08.54-pm.jpg
Which has been ordered by year, then in the second column by month i.e 2 = February

and placed into a new sheet that looks like this

http://www.excelforum.com/attachment...9.07.48-pm.jpg

Where you can see all the January or "1" have been put together from the years of 2008 to 2013 and placed side by side for comparison.

Then the above formula to group all the makes and models and have a tally should be added to have the top performers at the top.

I've attached a sample before and after i hope this helps I look forward to hearing from you soon. Thank you again for everything.


Thank you so much everyone I really appreciate your help, I hope to hear from you all soon as I'll be using this for a uni assignment and my lecturer is stumped.


Thanks again.