Work Out Top 100 parts by Value including a part count out of a list of 500

[davidawright]

Hi.

Hope you can help.

As the title suggests I need to work out top 100 parts from a list of 500 by highest value and including the comodity and number of parts from the comodity.

If you view the attached it may explain things alot better.

The top chart shows how i need to present my findings. The bottom chart shows how my data is laid out.

(the attached is not real data so I have made it up for an example looking at top 5 parts against a list of 11)

Any help is appreciated.

Thanks, Dave

[davidawright]

infact how do i attach on here?