Prev: Countif across multiple sheets - sheet NAME issue?
Next: New free mail add-in for Excel/Outlook 2007-2010
From: arbe on 17 Feb 2010 15:16 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
From: Fred Smith on 17 Feb 2010 16:33 Highlight the range you want to sort before starting it. Regards, Fred "arbe" <arbe(a)discussions.microsoft.com> wrote in message news:56FFD696-D31F-4A99-AE8E-941C5C18D012(a)microsoft.com... >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
From: Gord Dibben on 17 Feb 2010 16:36
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 <arbe(a)discussions.microsoft.com> 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 |