Results 1 to 2 of 2
2001-11-13, 16:15 #1dilligaraGuest
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.
2001-11-14, 12:37 #2
- 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=http://www.smartcomputing.com/editorial/article.asp?article=articles/1999/s1006/1806/1806.asp>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>