Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > multiple results display after filter function
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Morphyus C via OfficeKB.com
 
Posts: n/a
Default multiple results display after filter function
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.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1
Reply With QuoteReply With Quote
  #2   Report Post  
Morphyus C via OfficeKB.com
 
Posts: n/a
Default
Morphyus C wrote:
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.


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


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Excel does not display multiple workbooks on the windows taskbar elg Excel Discussion (Misc queries) 1 January 1st 05 02:13 AM
Find & Replace results to display specified chosen fields samuel Excel Discussion (Misc queries) 1 December 28th 04 08:43 AM
in excel how to display results of a function and text in the sam. ez123 Excel Worksheet Functions 3 November 19th 04 01:16 PM
Data Filter - Not all rows in spreadsheet will display in Autofilt Excel Help Excel Worksheet Functions 1 November 17th 04 05:40 PM


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement