Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count values in a column, but. . .
First, apologies: My question must be answered in this and countless other
forums, but I can scarcely even begin to 'formulate' my question in search syntax. So here goes. I have a table with the columns Name (of people) and Town. (There are other columns, but these are the two I'm concerned with.) I want to count the number of people there are for each Town, but count each person only once. For instance - NAME TOWN person1 town1 person1 town1 person2 town1 person3 town2 person3 town2 person4 town3 The results I'm looking for would be - TOWN COUNT (of individual people) town1 2 town2 1 town3 1 Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
Count cells w/values in column if the data in column a matches cri | Excel Worksheet Functions | |||
Count entries in one column based on values in another column | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Can I count values in column 1 if criteria in column 2 are met | Excel Worksheet Functions |