| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
results display in filter function
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 -- 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 | |||
| multiple results display after filter function | Excel Worksheet Functions | |||
| FORECAST function isnt producing wanted results | Excel Discussion (Misc queries) | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| How to make Bullen's FilterCriteria() data refresh real-time? | Excel Discussion (Misc queries) | |||
| Function Formula is displayed not results | Excel Worksheet Functions | |||
Hybrid Mode
