| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Link 2 sheets
I keep a list of all 200 products we sell and how many of each sold per month.
I would like excell to automatically list a top ten list on another sheet. How can I do this ? |
|
#2
|
|||
|
|||
|
Hi
I'd try a pivot table for this. See: http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html http://www.ozgrid.com/Excel/excel-pivot-tables.htm http://www.techonthenet.com/excel/pivottbls/index.htm http://www.dicks-blog.com/archives/2...ble/trackback/ -- Regards Frank Kabel Frankfurt, Germany "bruno borgata" <bruno schrieb im Newsbeitrag ... I keep a list of all 200 products we sell and how many of each sold per month. I would like excell to automatically list a top ten list on another sheet. How can I do this ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i link sheets in my excel workbook | Excel Worksheet Functions | |||
| Past Link then copy | Excel Discussion (Misc queries) | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
| How do I link sorted data to other workbook sheets? | Excel Worksheet Functions | |||
| How do Icreate link from page of contents to sheets in workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
