Ranking tables from Excel data

Posted by Joe on Super User See other posts from Super User or by Joe
Published on 2012-09-22T10:03:17Z Indexed on 2012/09/23 9:40 UTC
Read the original article Hit count: 219

Filed under:

Hi all (asking here because this meta question told me to).

I have some data in an excel spreadsheet here. It's no more than a table with about five columns.

Year Purchased  Manufacturer            Model           Num  Unit Price      Total Price
        2007    SMARTBOX                FuturePad XP    1    £2,915.00   £2,915.00 
        2007    Attainment Company Inc  Go Talk 9+      1    £104.00     £104.00 
        2007    Attainment Company Inc  Go Talk 20+     1    £114.00     £114.00 

I'd like to be able to build a 'top ten' of either manufacturers or models (and I'd like to be able to do it by either most mentioned, most sales, or highest value of sales) - but I've got no idea what the best method is in excel. Any suggestions...?

The ideal output might be a set of sells that says something like

Company Units
A   5342
B   232
C   2
D   1

© Super User or respective owner

Related posts about microsoft-excel