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?