Frequency

F

Fred Roven

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.
 
G

Guest

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
 
B

Biff

Hi!
cannot figure out how to keep the zero as first digit
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VLOOKUP to Work Two Ways 0
Pulling partial information from a cell 2
Need to convert list of 5 digit zip codes to ranges where possible 3
How can I get a leading zero (ZIP code) to show in a LEFT() calc? 2
Format>Cells>Special>Zip Code 5
Combining Uneven Columns 2
Function to Count Zip Code Digits With Leading Zero 2
How to merge Excel address columns when some zips begin with zeros 4

Top