D
Dos Equis
Hi,
I'm trying to count zip codes in a dynamic fashion. Is there a
function which will identify what zips are present assigning each 2
cells as follows:
A1 B1 C1 D1
88001 12
A2 B2 C2 D2
88002 48
A3 B3 C3 D3
88005 17
So basically figure out what is there and how many times it occures in
a column, I know I can set up a COUNTIF function, but I don't want to
have to do that each time I ad a zip and I only want the spreadsheet so
large... I'm sure I've missed someting obvious, but can't for the life
of me find it.
Thanks,
Byron
I'm trying to count zip codes in a dynamic fashion. Is there a
function which will identify what zips are present assigning each 2
cells as follows:
A1 B1 C1 D1
88001 12
A2 B2 C2 D2
88002 48
A3 B3 C3 D3
88005 17
So basically figure out what is there and how many times it occures in
a column, I know I can set up a COUNTIF function, but I don't want to
have to do that each time I ad a zip and I only want the spreadsheet so
large... I'm sure I've missed someting obvious, but can't for the life
of me find it.
Thanks,
Byron