help with sorting
i import multiple data (500 rows or more) and it comes across a follows: first name last name address 1 address 2 (not always present) city, state zip there are no empty rows in between each row and the data in each row i only in 1 cell. I am trying to sort by either city or zip but maintai the grouping intact. any help would be greatly appreciate -- acarri ----------------------------------------------------------------------- acarril's Profile: http://www.excelforum.com/member.php...fo&userid=1002 View this thread: http://www.excelforum.com/showthread.php?threadid=27741 |
help with sorting
Are all zip codes 5 numbers? (as opposed to a 9 digit zip code)
Just to verify City, state zip is all in one cell in column A. -- Regards, Tom Ogilvy "acarril" wrote in message ... i import multiple data (500 rows or more) and it comes across as follows: first name last name address 1 address 2 (not always present) city, state zip there are no empty rows in between each row and the data in each row is only in 1 cell. I am trying to sort by either city or zip but maintain the grouping intact. any help would be greatly appreciated -- acarril ------------------------------------------------------------------------ acarril's Profile: http://www.excelforum.com/member.php...o&userid=10027 View this thread: http://www.excelforum.com/showthread...hreadid=277418 |
All times are GMT +1. The time now is 01:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com