ExcelBanter - sorting multiple columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sorting multiple columns (https://www.excelbanter.com/excel-worksheet-functions/256599-sorting-multiple-columns.html)

arbe

sorting multiple columns

I have multiple addresses on a work sheet. I need to have all the same zip
code # together. How do I sort them by zip code so right name and address
ends up with right zip code

Fred Smith[_4_]

sorting multiple columns

Highlight the range you want to sort before starting it.

Regards,
Fred

"arbe" wrote in message
...
I have multiple addresses on a work sheet. I need to have all the same zip
code # together. How do I sort them by zip code so right name and address
ends up with right zip code

Gord Dibben

sorting multiple columns

Pre-select all the columns before sorting on Zip Code.

Gord Dibben MS Excel MVP

On Wed, 17 Feb 2010 12:16:02 -0800, arbe
wrote:

I have multiple addresses on a work sheet. I need to have all the same zip
code # together. How do I sort them by zip code so right name and address
ends up with right zip code

All times are GMT +1. The time now is 12:14 AM.