The INDEX Formula is an Array formula, and is to be confirmed with
CTRL+SHIFT+ENTER rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
Excel, when the formula is entered as an Array formula.
Copy down the formulas until getting an Error
http://img690.imageshack.us/img690/2973/nonamet.png
Micky
"tkraju via OfficeKB.com" wrote:
Yes, with pure formulas.
מיכאל (מיקי) אבידן wrote:
If you would like to accomplish that with "pure" formulas [NO FILTERING] -
let us know.
Micky
1 name amount
2 Paul 200
[quoted text clipped - 10 lines]
How to achieve this in Excel?
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201003/1
.