filtered values can displayed in certain cell

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

Morphyus C via OfficeKB.com

Hi Folks, is there a possibility that once filtered, the value can be
transfer to a cell. For example:
TYPE RATE MAT AMT FLOOR CAP OFFSET
1 6.00% Jan-06 2,000 4.00% 19.00% 0.25
1 6.00% Jan-06 3,201 4.00% 19.00% 2.00
1 6.00% Jan-06 2,000 5.00% 19.00% 0.50

3 6.00% ???? $7,201.00 4.28% 19.00%

so under TYPE 1 we have three values that correspod Jan-06 and I'm trying if
that Jan-06 can be displayed in ????? place.
Help will be greatly appreciated.
Thanks
Morphyus
 

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

results display in filter function 0
multiple results when using filter function 2
multiple results display after filter function 1
Formulas displayed in cell rather than calculated values? 5
variable gaps 1
VLOOKUP Function returning multiple values in a separate table 8
increments 5

Top