sorting rows

  • Thread starter Thread starter antony
  • Start date Start date
A

antony

please can you help me with a sorting issue.

I need to sort rows in assending order, by this I mean where a row ha
just two columns i would like this at the top of the worksheet, an
then where there are blocks of three, four,five columns and so on. th
data sort function does not seem to be able this do this for me. I a
using excel 2002.

thanx in advanc
 
antony,

Sort based on a helper column that has the formula that counts the block
size. For example, insert a new column A, and in cell A1, use the formula

=COUNTA(B10:Z1)

And copy down to match your range. Adjust the range reference as needed to
capture your range of interest.

HTH,
Bernie
MS Excel MVP
 
Back
Top