First thing that comes to my mind is two things.

Idea 1:
You're row counter is incrementing correctly, perhaps one of the quotation
marks is in wrong spot? Check to make sure both formulas match.

Idea 2:
Since results are only first line of data, your formula does not appear to
be operating as an array. Make sure formula is confirmed using
Ctrl+Shift+Enter, not just enter, and XL puts the curly brackets in itself.

Also, since your formula is returning a result, you must somehow have this
corrected, but the formula you posted is unbalanced in it's parathensis. By
this I mean, you have 2 more )'s than ('.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Gene" wrote:

I got the following formula from a book which was accompanied by a CD. I
downloaded the example which did exactly what I wanted. When I dluplicated
the example on a new workbook, however, it did not work.


{IFERROR(INDEX(Data,SMALL(IF(Data<"",ROW("1:"&ROW S(Data)))),ROW("1:"&ROWS(Data))))),"")}

Data Result My Result
33 33 33
-10 -10 33
20 33
20 15 33
etc. I think I have the latest updates for 2007 and the book
was of course written some time ago. I evaluated the formulas and the
process was the same on both the download and my worksheet. Only the result
was different. Can someone advise.?
--
GeneS