Thread: Sorting Data
View Single Post
  #1   Report Post  
vik
 
Posts: n/a
Default Sorting Data

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