Quick question for all the Exel gurus on this forum:

I have a spreadsheet with the following fields dumped into one row:
Ministry,Load Date,Fiscal End,Vendor Name

Below that I have over 9000 rows with the info related to the above fields.
What I want to know is how would I sort the data so that I could find out how
many total contracts vendor X was given for example regardless of ministry?

Can I use Excel to sort it or do I need to create a function or a query in VB?

any help is appreciated.

Thanks,
Vik