LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Count unique entries across multiple columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count unique values across two columns with multiple conditions Ert Excel Worksheet Functions 4 March 8th 09 12:22 AM
count if unique entries Tonybagodonuts Excel Worksheet Functions 3 July 15th 08 06:10 AM
Count unique entries... ChuckF Excel Worksheet Functions 5 October 12th 06 05:48 AM
Count unique entries BeSmart Excel Worksheet Functions 7 August 30th 05 12:53 PM
how to count unique entries with multiple condition Michael Excel Worksheet Functions 6 June 29th 05 12:38 PM


All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"