multiple results display after filter function

  • Thread starter Morphyus C via OfficeKB.com
  • Start date
M

Morphyus C via OfficeKB.com

TYPE RATE MAT AMT FLOOR CAP OFFSET
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Jan-06 2,000 4.00% 19.00%
1 5.00% Feb-09 3,000 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Mar-06 4,000 4.00% 19.00%
1 5.00% Feb-08 1,250 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Jan-06 3,201 4.00% 19.00%
1 5.00% Feb-08 2,000 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Jan-06 2,000 5.00% 19.00%
1 5.00% Feb-08 3,000 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Mar-06 4,000 4.00% 19.00%
1 5.00% Feb-08 1,250 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00



TYPE 9 RESULTS
6.00% Jan-06 7,201 4.28% 19.00% TYPE 9
4 5.00% Feb-08 7,500 5.00% 20.00% TYPE 9
1 5.00% Feb-09 3,000 5.00% 20.00% TYPE 9
2 6.00% Mar-06 8,000 4.00% 19.00% TYPE 9



398 6.21% $38,061.00 4.00% 18.63% Total

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.
 
M

Morphyus C via OfficeKB.com

Morphyus said:
TYPE RATE MAT AMT FLOOR CAP OFFSET
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Jan-06 2,000 4.00% 19.00%
1 5.00% Feb-09 3,000 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Mar-06 4,000 4.00% 19.00%
1 5.00% Feb-08 1,250 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Jan-06 3,201 4.00% 19.00%
1 5.00% Feb-08 2,000 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Jan-06 2,000 5.00% 19.00%
1 5.00% Feb-08 3,000 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Mar-06 4,000 4.00% 19.00%
1 5.00% Feb-08 1,250 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00


TYPE 9 RESULTS
6.00% Jan-06 7,201 4.28% 19.00% TYPE 9
4 5.00% Feb-08 7,500 5.00% 20.00% TYPE 9
1 5.00% Feb-09 3,000 5.00% 20.00% TYPE 9
2 6.00% Mar-06 8,000 4.00% 19.00% TYPE 9



398 6.21% $38,061.00 4.00% 18.63% Total

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.
Click to expand...


CAN SOMEONE PLEASE HELP ME ON THIS ISSUE????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple results when using filter function 2
Formula to get the Ans 4
Formula to get 3
Sorting and maintaining formula integrity 5
Conditional lookup 2
Subtract if dates in the range between 2 dates. 2
YTD average cust calulation 3
Indirect & Match Formula Problem 1

Top