Results 1 to 2 of 2
  1. #1

    Sort, Pivot Table, or What? (Excel 97 SR-2)

    I'm trying to extract a summary and/or report/display from a school fund raising spreadsheet. The workbook contains a worksheet page for each grade k thru 8. The student names are listed in rows and the columns have the items for sale, with totals columns. We want to be able to find the top ten sellers, and/or sort all off the students sales data by number of items sold, or total sales in dollars.

    I've tried creating a summary sheet and pasting the students from each class as a link, but it gets screwed up because there is more than one header row.

    I've attached one class sheet as an example.

    Thanks for your help.

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Springfield, Ohio, USA
    Thanked 2 Times in 2 Posts

    Re: Sort, Pivot Table, or What? (Excel 97 SR-2)

    Have you looked into the Data, Consolidate... menu item. Unfortunately, the help file is terrible, so you may want to borrow an Excel textbook. <A target="_blank" HREF=>Here</A> is a tutorial. Don't know if it's good; haven't worked through it. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts