In article ,
willemeulen wrote:

This Ctrl+Shift+Enter thing, array or something they call it. I read in
some of the forums you should avoid it when possible as it has some
disadvantages.

In general, array formulas, which need to be confirmed with
CONTROL+SHIFT+ENTER, take longer to calculate. If the range is
relatively small and the worksheet doesn't contain many of them, then it
likely won't be an issue. However, if the range is large and the
formula is copied to many cells, it can really slow down the worksheet.

Once done does it work or should the user repeat it after the sheet has
been modified?

The only time an array formula needs to be re-confirmed with CSE is
after modifying the formula itself.

I would like to avoid that as I'm writing the sheet for
other people to use, and they are complete with Excel.

Assuming that A2:A9 contains the data, try...

C2:

=SMALL(A2:A9,1)

C3, copied down until the formula returns #NUM!:

=SMALL($A$2:$A$9,COUNTIF($A$2:$A$9,"<="&C2)+1)

--
Domenic
http://www.xl-central.com