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. |
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. |
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. |
All times are GMT +1. The time now is 01:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com