How do I place items in alphabetical order in a column and keep da

[Guest]

How do you make a column automatically place items in alphabetical order?
Also, how do you make a column automatically put dates in order? Trying to
create a chart with will help me to monitor my clients progress. Any advice
will help!!

 

[RagDyer]

If "Items" are either *all* text, or *all* numbers, and are in Column D,
from D150, try this *array* formula in a "helper" column:

=INDEX($D$1:$D$50,MATCH(SMALL(COUNTIF($D$1:$D$50,"<"&$D$1:$D$50),ROW(A1)-ROW
($A$1)+1),COUNTIF($D$1:$D$50,"<"&$D$1:$D$50),0))

--
Array formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of the
regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

For dates in Column C, try this also in a "helper" column:

=SMALL($C$1:$C$50,ROW(A1))

Make sure the column containing the formula is formatted to Dates.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Guest]

With your items (could be dates) in cells A1 to A8:
Cell B1:
=SUMPRODUCT(--($A$1:$A$6<$A1))+1+ROW(A1)/1000
Cell C1:
=RANK($B1,$B$1:$B$8,5)
Cell E1:
=ROW(A1)-ROW($A$1)+1
Cell F1:
=A1
Cell G1:
=SUMPRODUCT($E$1:$E$8,--($C$1:$C$8=$E1))
Cell I1:
=VLOOKUP($G1,$E$1:$F$8,2)
Copy B1 to I1 down.
Columns A, F and I must be formatted according to whether you have dates or
other type of text.
Column F contains the ordered list.

 

[Guest]

How do you make a column automatically place items in alphabetical order?
Also, how do you make a column automatically put dates in order? Trying to
create a chart with will help me to monitor my clients progress. Any advice
will help!!

 

[Guest]

How do you make a column automatically place items in alphabetical order?
Also, how do you make a column automatically put dates in order? Trying to
create a chart with will help me to monitor my clients progress. Any advice
will help!!

 

[timzout]

RE: HOW DO I PLACE ITEMS IN ALPHABETICAL ORDER IN A COLUMN?

angela33 thanks for your "tips", but i'm not sure what to do after I
"copy B1 to I1 down". Do you mean to copy the cells from B1 and insert
it to I1, or copy everything below B1 and I1, and then what so i do
after i copy the cells. My goal is to create a formula or micro so
Excel can automatically descend my numbers as i input them in a column.

thanks,
timzout

 

[Guest]

For some reason, when I use this formula, all I get is the first item every
time. Is there any chance there is an error somewhere?

 

[Gord Dibben]

Good chance you are set to Manual calculation.

Tools>Options>Calculation. Set to "automatic".


Gord Dibben MS Excel MVP