results display in filter function

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

Morphyus C via OfficeKB.com

Good Morning Folks...
is this possible that multiple related results can be displayed when use
filter functions? For example,
TYPE RATE MAT AMT FLOOR CAP
1 6.00% Jan-06 2,000 4.00% 19.00%
1 5.00% Feb-09 3,000 5.00% 20.00%
2 6.00% Mar-06 4,000 4.00% 19.00%
2 5.00% Feb-08 1,250 5.00% 20.00%
1 6.00% Jan-06 3,201 4.00% 19.00%
if we do filter, TYPE will have two entitities in it. and here is the result:

TYPE RATE MAT AMT FLOOR CAP
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% Jan-06 3,201 4.00% 19.00%
If I further filter this by MAT, I will get two more results by date and thst
is:
TYPE RATE MAT AMT FLOOR CAP
1 6.00% Jan-06 2,000 4.00% 19.00%
1 6.00% Jan-06 3,201 4.00% 19.00%
I'm after if all the results can be displayed at once. Please ask me for
further explanation.
thanks
 

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
multiple results display after filter function 1
filtered values can displayed in certain cell 0
In Excel2002-To find&copy specified "Statements" via Access2002 to 1

Top