ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Create a list with multiple criteria (https://www.excelbanter.com/excel-programming/442782-create-list-multiple-criteria.html)

Ronbo

Create a list with multiple criteria
 
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


All times are GMT +1. The time now is 04:36 PM.

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