Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Count only once with multiple columns
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="jhicsupt, post: 3219046"] I have two columns: A B Cancelled ABC Company Cancelled ABC Company Active ABC Company Cancelled ABC Company Cancelled XYZ Company Cancelled John Doe Company Active The Smith Company So I want to return this: Cancelled 3 Active 2 Meaning that there are 3 unique values counted once that are "Cancelled" there are 2 unique values counted once that are "Active" Thanks in advance [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Count only once with multiple columns
Top
