Sorting a portion of a range

G

gbeard

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,
 
G

Gary Brown

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
 
Top