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
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
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!
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 ???
Need a formula to sort instead of using the manual sort.
Thanks
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 .
Only need values in G2:G10 sorted alphabetically.
Thanks
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.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Tony Valko: great! still looking for a formula to sort G2:G12 but keep blank rows. Thanks
You have sort G2 to I12 as a group otherwise the H and I columns will not match column G.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks