Sotring Data and Frequency of Entries

Hi all, this is my first post here, so be gentle:p

Basically, i have a spreadsheet that has a list of commodity codes (numbers assigned to products in a catalogue), and in another column i have a percentage of discount next to each commoidty code. Example:

75430 40%
69987 57%
57137 55%
75430 34%
69969 34%
69982 56%
48226 100%
42141 35%
48246 100%
75430 100%
69983 69%
69983 40%
69983 50%
69987 74%

(There is much more than is just an example)

I basically need a Pivot Table / or a Chart that shows which commodity is most frequently discounted and how much by.

What would be the most easiest way to do this? Any help would be mucho appreciated!!!

Thanks guys,
Dale

Hi Zbor

Thanks so much for replying, do you use MSN or anything i could maybe talk to you on without having to spam this thread? Or is that not a problem

Cheers mate