Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a data base with 1,000's of addresses w/zipcodes (Sheet 1 columns A to
E, E being zipcodes). After setting a base address I get all of the zipcodes within a given radius (in this case 70 zipcodes), listed in Sheet 2, Column A. Next, I use COUNTIF (in column B) to find how many addresses are in each zipcode, in this example there are 46 addresses within the 70 zipcodes. What I want to do is create a list in sheet three that will list each with the data from Sheet 1 columns A to E). Any help would be appreciated. Ronbo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a list using two criteria | Excel Programming | |||
create list based on criteria | Excel Worksheet Functions | |||
create new table from Multiple Criteria in multiple columns | Excel Worksheet Functions | |||
Create list from criteria | Excel Discussion (Misc queries) | |||
Create list of text matching criteria | Excel Worksheet Functions |