Re: Help with Excel Query

Thanks a lot dave, I appreciate the reply.

Regards,
Vik

"Dave Peterson" wrote:

> You can use Data|Sort to sort by the vendor name, then Data|subtotals to get
> your counts.
>
> Alternatively, you may want to learn about Data|Pivottable.
>
> You may want to look at some links:
>
> Debra Dalgleish's pictures at Jon Peltier's site:
> http://peltiertech.com/Excel/Pivots/pivottables.htm
> And Debra's own site:
> http://www.contextures.com/xlPivot01.html
>
> John Walkenbach also has some at:
> http://j-walk.com/ss/excel/files/general.htm
> (look for Tony Gwynn's Hit Database)
>
> Chip Pearson keeps Harald Staff's notes at:
> http://www.cpearson.com/excel/pivots.htm
>
> MS has some at (xl2000 and xl2002):
> http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
> http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx
>
> Vik wrote:
> >
> > Quick question for all the Exel gurus on this forum:
> >
> > I have a spread*** 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
>
> --
>
> Dave Peterson
>
.