troubleshooting Question

Sorting just a selection of rows on a spreadsheet

Avatar of Rowby Goren
Rowby GorenFlag for United States of America asked on
Microsoft ExcelVB Script
15 Comments3 Solutions198 ViewsLast Modified:
Hello Excel Experts

I have a spreadsheet with names and addresses.  The spreadsheet is initially arranged by zip code (In the attached, the column is called Property Zip)  (there is also a Mailing zip, but I am ignoring that)

Basically what I want to do is to be able to select a block of rows and sort that block by (in this case, by the Square footage column.

For example, in the attached sheet I have 3 zip code rows in the Property Zip column  90064, 90066 and 90402

First I want to be able to select the 90064 rows, and sort those rows by the Square Footage column.  (and not affect any other rows in other zip codes, of course -- that is why I am selecting the 90064 rows). :)

Then I want to select the 90066 rows and sort those rows by the Square footage column.

Finally I want to select the 90402 rows and sort those rows by the Square footage column.)

In summary -- I  know how to sort, but I don't know how to sort within a row selection -- and not affect any other row(s) that are not selected.

Any suggestions?  The attached is a small file, but I have much bigger files that I have to do this with.

Is this core basic Excel.  OR do I need a formula to do this?
Rob Henson
Finance Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros