maybe if you use some kind of filter you would have the data you need, i
mean, in the menu bar, in the top, you can find a option "Data" then "Filter"
and "Auto filter".

good luck.

"vik" wrote:

Quick question for all the Excel 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