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

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