Sorting Text Alphabetically

[bjnockle]

Looking for formula to extract values from G2:G10 and sort in ascending order in A17:A27 and still keep the blanks when values are extracted. See attached sample file

[JohnTopley]

If you had retained the formulas in A17 etc. and simple sorted the data in I by product (I assume you do want sort within product) i.e, selected the 4 rows for Apples and sorted them, problem solved!

[JohnTopley]

I headed Column F as "Code"

Then Custom Sort

Code ==>Z to A
Product ==> Z to A
Nutrition ==> A to Z
Facts ==> A to Z

Is this the order required ???

[bjnockle]

Need a formula to sort instead of using the manual sort.

Thanks

[JohnTopley]

How is a formula going to sort the following ....???

Reduce cancer risk
Reduce diabetes

At best you will need a purpose-written VBA macro: so why not sort your input table .

[bjnockle]

Only need values in G2:G10 sorted alphabetically.

Thanks

[Tony Valko]

How is a formula going to sort the following ....???

Reduce cancer risk
Reduce diabetes

Like this...

Data Range

	A	B
1	Random	Sorted Ascending
2	Reduce diabetes	Reduce cancer risk
3	Reduce cancer risk	Reduce diabetes

This array formula** entered in B2 and copied down:

=INDEX(A$2:A$3,MATCH(LARGE(COUNTIF(A$2:A$3,">"&A$2:A$3),ROWS(B$2:B2)),COUNTIF(A$2:A$3,">"&A$2:A$3),0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[bjnockle]

Tony Valko: great! still looking for a formula to sort G2:G12 but keep blank rows. Thanks

[JohnTopley]

You have sort G2 to I12 as a group otherwise the H and I columns will not match column G.

[bjnockle]

John Topley: I can use helper column to make it match. Just looking to sort G2:G12 and still keep blank rows as is.

Thanks