| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling Data from an Array
I have a production schedule that has dates accross the top and models
down the side. I want to be able to summarize the products that need to be build each day instead of showing all the data. Example Data Source 11/1/2005 11/2/2005 11/3/2005 11/4/2005 11/5/2005 11/6/2005 FF100 25 50 180 0 0 0 FF101 0 100 0 0 0 0 FF102 25 0 0 75 150 0 FF103 0 0 0 0 0 150 FF104 0 0 0 0 0 0 FF105 25 100 0 0 0 0 FF106 0 0 0 0 0 0 FF107 50 25 0 75 25 0 FF108 25 0 0 0 0 0 Expected Summary FF100 11/1/2005 25 FF102 11/1/2005 25 FF105 11/1/2005 25 FF107 11/1/2005 50 FF108 11/1/2005 25 FF100 11/2/2005 50 FF101 11/2/2005 100 FF105 11/2/2005 100 FF107 11/2/2005 25 FF100 11/3/2005 180 FF102 11/4/2005 75 FF107 11/4/2005 75 FF102 11/5/2005 150 FF107 11/5/2005 25 I have tried various functions but can not get it to work. Anyone have a suggestion? Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please add an INTERPOLATE function. For vector or array data. | Excel Worksheet Functions | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
| Pulling data from yyyyMMMMdd.xls | Charts and Charting in Excel | |||
| How do I return an entire row of data from a reference array? | Excel Worksheet Functions | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Threaded Mode
