ST Alpha - "I know I can count unique values using an array formula, but can I say " (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 158

I know I can count unique values using an array formula, but can I say

Posted by amanda Nov 9 '12, 09:10

"only count the unique values in column B (student IDs) if the column C is fayette (campus)"?

thanks guys.

Responses:

try adding something like *(A2:A2000="fayette") to the condition of your if function -- nm - zork Nov 9, 09:47 2
- I did this: - amanda Nov 9, 09:51 1
  - thanks as always for being willing to help. I have SRAA documentation in the next week or so so might reach out to you for VBA assistance. - amanda Nov 9, 09:53

Post a message top

Replies are disabled on threads older than 7 days.