software

I have one column of unsorted cells.

I want to create a second column with the sorted values from the first
column.

I can easily copy/paste the first column and then manually use the sort
menu command. But I want to do that via a worksheet function so that
when I change the unsorted values in the first column, the sorted
column automatically updates.

Make sense? I need to keep both the unsorted and sorted versions of the
same data.--
RogerWilco
------------------------------------------------------------------------
RogerWilco's Profile: www.excelforum.com/member.php...oamp;userid=18906
View this thread: www.excelforum.com/showthread...hreadid=499625What kind of data is this for? Text? Numeric? Mixed? Any duplicates?

Biff

quot;RogerWilcoquot; gt; wrote
in message ...
gt;
gt; I have one column of unsorted cells.
gt;
gt; I want to create a second column with the sorted values from the first
gt; column.
gt;
gt; I can easily copy/paste the first column and then manually use the sort
gt; menu command. But I want to do that via a worksheet function so that
gt; when I change the unsorted values in the first column, the sorted
gt; column automatically updates.
gt;
gt; Make sense? I need to keep both the unsorted and sorted versions of the
gt; same data.
gt;
gt;
gt; --
gt; RogerWilco
gt; ------------------------------------------------------------------------
gt; RogerWilco's Profile:
gt; www.excelforum.com/member.php...oamp;userid=18906
gt; View this thread: www.excelforum.com/showthread...hreadid=499625
gt;

They are all numeric and there can be duplicates... Does that matter?
Can't you do a sort regardless of data type?--
RogerWilco
------------------------------------------------------------------------
RogerWilco's Profile: www.excelforum.com/member.php...oamp;userid=18906
View this thread: www.excelforum.com/showthread...hreadid=499625To sort a range of cells that is all NUMERIC:

Assume the range is A1:5:

To sort ascending:

=SMALL(A$1:A$5,ROWS($1:1))

Copy down 5 cells.

To sort descending just replace SMALL with LARGE.

To sort a range of cells that is all TEXT:

To sort ascending:

Entered as an array using the key combo of CTRL,SHIF,ENTER:

=INDEX($A$1:$A$5,MATCH(SMALL(COUNTIF($A$1:$A$5,quot;lt;quot; amp;$A$1:$A$5),ROWS($1:1)),COUNTIF($A$1:$A$5,quot;lt;quot;amp;$A$1 :$A$5),0))

Copy down 5 cells.

To sort descending replace SMALL with LARGE.

Don't even ask to sort mixed data!!!! (both TEXT and NUMERIC)

Biff

quot;RogerWilcoquot; gt; wrote
in message ...
gt;
gt; They are all numeric and there can be duplicates... Does that matter?
gt; Can't you do a sort regardless of data type?
gt;
gt;
gt; --
gt; RogerWilco
gt; ------------------------------------------------------------------------
gt; RogerWilco's Profile:
gt; www.excelforum.com/member.php...oamp;userid=18906
gt; View this thread: www.excelforum.com/showthread...hreadid=499625
gt;