Sorting a portion of a range

[gbeard]

I have a range, A1150, 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 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