Would like to use formula to sort a single value/letter in ascending order.
For example, A G A A A K K H H H should be A A A A G H H H K K
Thanks
Would like to use formula to sort a single value/letter in ascending order.
For example, A G A A A K K H H H should be A A A A G H H H K K
Thanks
Assuming that the data is in A1:A10. In B1 and copy down the following CSE formula. That is to commit the formula use the CTRL + SHIFT + ENTER.
Formula:=INDEX($A$1:$A$10,MATCH(SMALL(COUNTIF($A$1:$A$10,"<="&$A$1:$A$10),ROW(A1)),COUNTIF($A$1:$A$10,"<="&$A$1:$A$10),0))
Solution works like a charm, Crisp Packet. Thanks
maybe DATA > Sort > Option > Sort Left to Right? (with case sensitive or not)
thanks, bjnockle
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks