Sorting 2 or more rows

[joneill]

Is it possible to sort and keep two or more rows together?

I have a customer list that has the customer name in row #1 then in ro
#2 and #3 are that customers branches, along with there total loans.
want to sort descendingly on the total customer loans, but keep th
customer and branches together

Example:

#1 First Union Bank
#2 First Union Bank North 5 loans
#3 First Union Bank South 10 loans
#4 Total 15 loans

#5 American Bank
#6 American Bank South 4 loans
#7 American Bank North 16 loans
#8 Total 20 loans

In the end report rows #5-8 need to stay together but be listed first
before rows #1-4)

Thanks for any hel

 

[Frank Kabel]

Hi
one way: Try using a helper column with the following
formula
C1:
=A1&"1"

C2:
=IF(A2="Total",A1 & COUNTIF($A$1:$A2,A1)+1,A2 & COUNTIF
($A$1:$A2,A2))
and copy this down. Now sort with this helper column