ST Alpha - "excel help! column C contains names. column D contains names." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

excel help! column C contains names. column D contains names.

Posted by amanda Apr 27 '15, 10:01

I want to count unique people who are on the BLUE team. I can count unique all values, but how do I add the "if BLUE" qualifier?

thanks guys. I know it has to be doable with an array.

Responses:

I did this. it's not pretty but it gets the job done. - amanda Apr 27, 10:22
COUNTIF -- nm - oblique Apr 27, 10:07
I think you're going to find it in this mix of DCOUNT and DCOUNTA -- (link) - Will Hunting Apr 27, 10:06

Post a message top

excel help! column C contains names. column D contains names.

Replies are disabled on threads older than 7 days.