Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Frequency
Any ideas how to write this function or where I might go for help?
I have a column of 5 digit zip codes and column of frequecy of those zip codes. I would like to find the frequency of the first three digits of zip codes (***xx) I have started by multiplying by.01 but cannot figure out how to keep the zero as first digit. I started ? manually but realized I would be here all night. Too nice a day for that. Thanks for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Frequency
two steps:
1. In a helper column enter =LEFT(A1,3) and copy down.This should get the first three digits 2. Apply the FREQUENCY() worksheet function -- Gary's Student "Fred Roven" wrote: Any ideas how to write this function or where I might go for help? I have a column of 5 digit zip codes and column of frequecy of those zip codes. I would like to find the frequency of the first three digits of zip codes (***xx) I have started by multiplying by.01 but cannot figure out how to keep the zero as first digit. I started ? manually but realized I would be here all night. Too nice a day for that. Thanks for any help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Frequency
Hi!
cannot figure out how to keep the zero as first digit Format the zip codes as TEXT so you can use a leading 0. Format the criteria cell as TEXT. criteria cell B1 = 018 =SUMPRODUCT(--(LEFT(A1:A20,3)=B1)) Biff "Fred Roven" wrote in message ... Any ideas how to write this function or where I might go for help? I have a column of 5 digit zip codes and column of frequecy of those zip codes. I would like to find the frequency of the first three digits of zip codes (***xx) I have started by multiplying by.01 but cannot figure out how to keep the zero as first digit. I started ? manually but realized I would be here all night. Too nice a day for that. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Frequency of Filtered Data | Excel Worksheet Functions | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
3-D Frequency Chart in VBA | Charts and Charting in Excel | |||
Combine FREQUENCY and SUM of Associated Values | Excel Worksheet Functions | |||
Frequency for Histograms in Excel | Charts and Charting in Excel |