PC Review


Reply
Thread Tools Rate Thread

Create a list with multiple criteria

 
 
Ronbo
Guest
Posts: n/a
 
      25th May 2010
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a list using two criteria Ronbo Microsoft Excel Programming 4 28th Jan 2010 06:46 PM
create list based on criteria Bexi Microsoft Excel Worksheet Functions 1 19th Jan 2010 08:51 PM
create new table from Multiple Criteria in multiple columns InfoSeeker Microsoft Excel Worksheet Functions 3 9th Nov 2008 06:54 AM
Create list from criteria Sunnyskies Microsoft Excel Misc 5 28th Aug 2008 09:43 PM
Create a list to be used as criteria =?Utf-8?B?SmVu?= Microsoft Access Queries 6 23rd Jul 2005 12:44 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:26 AM.