Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to count the number of unique entries over a group of columns.
For instance, I have the following in a spreadsheet: A B C D 1 Account User Fund Dept 2 5490 Sam 100 34 3 5490 Sam 100 34 4 5490 Sam 100 35 5 5491 Ted 200 34 6 5491 Fred 200 34 I am interested in the Account, Fund, and Dept columns which, when combined, form a unique entry. So I need the unique entry and its count. For instance: 5490 100 34 (2) 5490 100 35 (1) 5491 200 34 (2) Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count unique values across two columns with multiple conditions | Excel Worksheet Functions | |||
count if unique entries | Excel Worksheet Functions | |||
Count unique entries... | Excel Worksheet Functions | |||
Count unique entries | Excel Worksheet Functions | |||
how to count unique entries with multiple condition | Excel Worksheet Functions |