| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am trying to create a spreadsheet for businesses within zip code
I am trying to create a spreadsheet for businesses within zip codes. What I
would like to do is enter a zip code ie: 90620, and have the business number 523 returned to be part of, and create a total as shown below. Buena Park Zip 90620 La Palma Zip 90623 Cypress Zip 90630 Los Alamitos Zip 90720 Costa Mesa Zip 92626 Costa Mesa Zip 92627 TOPP Prospects 5,805 I am using Excel 2003 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am trying to create a spreadsheet for businesses within zip code
What does 523 have to do with anything in your sample data?
-- Thanks, Shane Devenshire "SM1" wrote: I am trying to create a spreadsheet for businesses within zip codes. What I would like to do is enter a zip code ie: 90620, and have the business number 523 returned to be part of, and create a total as shown below. Buena Park Zip 90620 La Palma Zip 90623 Cypress Zip 90630 Los Alamitos Zip 90720 Costa Mesa Zip 92626 Costa Mesa Zip 92627 TOPP Prospects 5,805 I am using Excel 2003 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am trying to create a spreadsheet for businesses within zip
Sorry, I should have been more specific. In this example 523 relates to the
number of businesses within that zip code. That number is different depending on zip code. I have the information, but no good way of compiling automatically, or quickly running senarios as to business potential within a planned sales territory. "ShaneDevenshire" wrote: What does 523 have to do with anything in your sample data? -- Thanks, Shane Devenshire "SM1" wrote: I am trying to create a spreadsheet for businesses within zip codes. What I would like to do is enter a zip code ie: 90620, and have the business number 523 returned to be part of, and create a total as shown below. Buena Park Zip 90620 La Palma Zip 90623 Cypress Zip 90630 Los Alamitos Zip 90720 Costa Mesa Zip 92626 Costa Mesa Zip 92627 TOPP Prospects 5,805 I am using Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I create a master spreadsheet from different workbooks | Excel Discussion (Misc queries) | |||
| How do I create a 1pg form for each row of data in a spreadsheet? | Excel Discussion (Misc queries) | |||
| Copy code to a new spreadsheet | Excel Discussion (Misc queries) | |||
| how do I create an invoice from a spreadsheet | New Users to Excel | |||
| Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Linear Mode
