Here are some formulas that will do what you wish.
You can enter these formulas in a "helper" column, which will display the
data in a sorted configuration.
For numbers *only*:
=SMALL($A$1:$A$100,ROW())
Drag down to copy.
Array formulas, courtesy of Harlan:
For *text* only:
=INDEX($D$1:$D$10,MATCH(SMALL(COUNTIF($D$1:$D$10,"<"&$D$1:$D$10),ROW()-ROW($
E$1)+1),COUNTIF($D$1:$D$10,"<"&$D$1:$D$10),0))
For numbers *AND* text:
=INDEX($A$1:$A$10,MATCH(SMALL(COUNTIF($A$1:$A$10,"<"&$A$1:$A$10)+COUNT($A$1:
$A$10)*ISTEXT($A$1:$A$10),ROW()-ROW($B$1)+1),COUNTIF($A$1:$A$10,"<"&$A$1:$A$
10)+COUNT($A$1:$A$10)*ISTEXT($A$1:$A$10),0))
Don't forget, the last 2 are array formulas, and must be entered using CSE
(<Ctrl> <Shift> <Enter>), which, if done correctly, will *automatically*
enclose the formulas in curly brackets.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
hi!
can i do auto sorting of cells without going to data>>sort or clicking the
a->z button to sort? what i required is that when the linked cells got the
data from
the source, it will sort by itself and that sorting won't affect the source.
Pls let me know how to do that. Thks!!!
