Ranking tables from Excel data
- by Joe
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