ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sorting into Columns (https://www.excelbanter.com/excel-worksheet-functions/67365-sorting-into-columns.html)

BanyanTree

Sorting into Columns
 

I am trying to sort a list of zip codes into Zones, in which each Zone
would include 3-4 zips......how do I ask the function of the cell to
say, "zip 1 or zip 2 or zip 3" ?


--
BanyanTree
------------------------------------------------------------------------
BanyanTree's Profile: http://www.excelforum.com/member.php...o&userid=30839
View this thread: http://www.excelforum.com/showthread...hreadid=505005


CLR

Sorting into Columns
 
Try Data Filter AutoFilter and choose Custom from the drop-down and use
the "Greater than or equal to" and "less than or equal to" options.........

Vaya con Dios,
Chuck, CABGx3



"BanyanTree" wrote:


I am trying to sort a list of zip codes into Zones, in which each Zone
would include 3-4 zips......how do I ask the function of the cell to
say, "zip 1 or zip 2 or zip 3" ?


--
BanyanTree
------------------------------------------------------------------------
BanyanTree's Profile: http://www.excelforum.com/member.php...o&userid=30839
View this thread: http://www.excelforum.com/showthread...hreadid=505005




All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com