Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Unique Entries | Excel Discussion (Misc queries) | |||
counting date entries by month & year | Excel Worksheet Functions | |||
Counting Duplicate Entries | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions |