| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
multiple results when using filter function
Good Morning Folks...
I will try my best to explain this. When you filter this the TYPE will show all the options in the drop down combo box. So far what I able to solve is that when select TYPE (let say for example TYPE 1), it will display the TYPE 1 related totals and weighted averages. Here is the result: TYPE RATE MAT AMT FLOOR CAP OFFSET 1 6.00% Jan-06 2,000 4.00% 19.00% 1 5.00% Feb-09 3,000 5.00% 20.00% 1 6.00% Mar-06 4,000 4.00% 19.00% 1 5.00% Feb-08 1,250 5.00% 20.00% 1 6.00% Jan-06 3,201 4.00% 19.00% 1 5.00% Feb-08 2,000 5.00% 20.00% 1 6.00% Jan-06 2,000 5.00% 19.00% 1 5.00% Feb-08 3,000 5.00% 20.00% 1 6.00% Mar-06 4,000 4.00% 19.00% 1 5.00% Feb-08 1,250 5.00% 20.00% 10 5.59% $25,701.00 4.49% 19.41% Total Now what I'm after is I like to see the result (which is further filter my MAT date) and should display at the same time. The result should be : TYPE RATE MAT AMT FLOOR CAP OFFSET 1 6.00% Jan-06 2,000 4.00% 19.00% 1 5.00% Feb-09 3,000 5.00% 20.00% 1 6.00% Mar-06 4,000 4.00% 19.00% 1 5.00% Feb-08 1,250 5.00% 20.00% 1 6.00% Jan-06 3,201 4.00% 19.00% 1 5.00% Feb-08 2,000 5.00% 20.00% 1 6.00% Jan-06 2,000 5.00% 19.00% 1 5.00% Feb-08 3,000 5.00% 20.00% 1 6.00% Mar-06 4,000 4.00% 19.00% 1 5.00% Feb-08 1,250 5.00% 20.00% TYPE 1 RESULTS 3 6.00% Jan-06 7,201 4.28% 19.00% TYPE 1 4 5.00% Feb-08 7,500 5.00% 20.00% TYPE 1 1 5.00% Feb-09 3,000 5.00% 20.00% TYPE 1 2 6.00% Mar-06 8,000 4.00% 19.00% TYPE 1 10 5.59% $25,701.00 4.49% 19.41% Total I really need help in this regard. Will really appreciate your input in this matter. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200508/1 |
|
#2
|
|||
|
|||
|
You can use a pivot table to summarize the data by type and date. There
are instructions in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm Morphyus C via OfficeKB.com wrote: Good Morning Folks... I will try my best to explain this. When you filter this the TYPE will show all the options in the drop down combo box. So far what I able to solve is that when select TYPE (let say for example TYPE 1), it will display the TYPE 1 related totals and weighted averages. Here is the result: TYPE RATE MAT AMT FLOOR CAP OFFSET 1 6.00% Jan-06 2,000 4.00% 19.00% 1 5.00% Feb-09 3,000 5.00% 20.00% 1 6.00% Mar-06 4,000 4.00% 19.00% 1 5.00% Feb-08 1,250 5.00% 20.00% 1 6.00% Jan-06 3,201 4.00% 19.00% 1 5.00% Feb-08 2,000 5.00% 20.00% 1 6.00% Jan-06 2,000 5.00% 19.00% 1 5.00% Feb-08 3,000 5.00% 20.00% 1 6.00% Mar-06 4,000 4.00% 19.00% 1 5.00% Feb-08 1,250 5.00% 20.00% 10 5.59% $25,701.00 4.49% 19.41% Total Now what I'm after is I like to see the result (which is further filter my MAT date) and should display at the same time. The result should be : TYPE RATE MAT AMT FLOOR CAP OFFSET 1 6.00% Jan-06 2,000 4.00% 19.00% 1 5.00% Feb-09 3,000 5.00% 20.00% 1 6.00% Mar-06 4,000 4.00% 19.00% 1 5.00% Feb-08 1,250 5.00% 20.00% 1 6.00% Jan-06 3,201 4.00% 19.00% 1 5.00% Feb-08 2,000 5.00% 20.00% 1 6.00% Jan-06 2,000 5.00% 19.00% 1 5.00% Feb-08 3,000 5.00% 20.00% 1 6.00% Mar-06 4,000 4.00% 19.00% 1 5.00% Feb-08 1,250 5.00% 20.00% TYPE 1 RESULTS 3 6.00% Jan-06 7,201 4.28% 19.00% TYPE 1 4 5.00% Feb-08 7,500 5.00% 20.00% TYPE 1 1 5.00% Feb-09 3,000 5.00% 20.00% TYPE 1 2 6.00% Mar-06 8,000 4.00% 19.00% TYPE 1 10 5.59% $25,701.00 4.49% 19.41% Total I really need help in this regard. Will really appreciate your input in this matter. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
Debra Dear...Thanks for the response. I actually tried for a week and did not
able to get the desired results. Do you think you can eloborate little bit more? Debra Dalgleish wrote: You can use a pivot table to summarize the data by type and date. There are instructions in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm Good Morning Folks... I will try my best to explain this. When you filter this the TYPE will show [quoted text clipped - 43 lines] I really need help in this regard. Will really appreciate your input in this matter. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200508/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can VLookup function find and list multiple records? | Excel Worksheet Functions | |||
| How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| Using function results as parameters in another function | Excel Worksheet Functions | |||
| Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) | |||
Linear Mode
