Match More than one
Posted by Sameer Bhide on November 06, 2001 6:30 PM
Consider a table below
The objective is to write a formula that looks for a maximum in column - "value" and displays the dats in column "Description" next to it.
In the above example the formula should display the following in one cell.
B G K (- in a single cell with space in b/w each character)
The formula below does that but displays the result only when you evaluate it using F9
Is there a workaround or an alternate way of achieving this.