Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting a portion of a range
I have a range, A1:P150, and I sort this range numerically based on columns
C throug P. Once it's sorted with the smallest on top, I'd like to sort alphabetically, based on column A, just those that are less than a threshold. Any ideas? Thanks again in advance, -- Gary Beard |
#2
|
|||
|
|||
Create another column with a formula of...
if A meets my criteria, enter 1, else enter 0 Something like =if(A2="New York",1,0) Sort on your C through P range then Sort on your new column with the above formula. HTH, Gary Brown "gbeard" wrote in message m... I have a range, A1:P150, and I sort this range numerically based on columns C throug P. Once it's sorted with the smallest on top, I'd like to sort alphabetically, based on column A, just those that are less than a threshold. Any ideas? Thanks again in advance, -- Gary Beard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
Sorting names in a range | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |