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.
Thanks for helping.
Looks good. So the steps I would take is to
1) Convert the entire sheet into a table. Looks like it is named the default Table 1. Remind me how to convert a spreadsheet into a table.
2) You created a custom sort. I know how to do a custom sort by two columns manually, but it looks like you built the two column sort that into the table.
Can you explain how you built in that custom sort
Then I will be able to use your solution on other similarly structured excel sheets.