This *array* formula would sort a "helper" column, which you could place
along side the actual data entry column.
Good for *only* text, OR *only* numbers, *not* a mixture of both.
=INDEX($A$1:$A$100,MATCH(SMALL(COUNTIF($A$1:$A$100,"<"&$A$1:$A$100),ROW()-RO
W($E$1)+1),COUNTIF($A$1:$A$100,"<"&$A$1:$A$100),0))
As an array formula, it *must* be entered using CSE (<Ctrl> <Shift>
<Enter>).
If done correctly, XL will *automatically* wrap the formula in curly
brackets, which *cannot* be done manually.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
As I enter new rows of data, I would like Excel to
automatically place the row in alpha order (I have sorted
the existing row in alpha order).
Any ideas?
Thanks in advance.
