Create a unique list with a count against the unique values

**barber87** · 07-12-2017, 09:01 AM

I have a data set which will contain a list of email addresses and if they have passed a course. There will be multiple unique email addresses with a true or false cell related to each email. i am wanting to produce a list of the unique email addresses and the count of how many times the related cell contains 'True'.

I have had numerous tries with COUNTIF formulas and INDEX formulas but have not been successful. Any help will be much appreciated. I have attached an example of the raw data and what i would like the data to look like afterwards.

Thanks in advance.

**davesexcel** · 07-12-2017, 09:10 AM

Possible, =countifs()

Formula:

Please Login or Register  to view this content.

**sweep** · 07-12-2017, 09:16 AM

Hi,

In D3 and copied down to cover the number of expected unique entries..

Formula:

Please Login or Register  to view this content.

In E3 and copied down to the extent of entries in column D...

Please Login or Register  to view this content.

**leelnich** · 07-12-2017, 10:13 AM

Hi all - This ARRAY FORMULA* produces an ALPHABETIZED list of unique e-mails. RawData is a named range (referring here to Sheet1!$A$3:$A$26).
Paste in D3 and copy down:

Formula:

Please Login or Register  to view this content.

Paste this in E3 and down for the counts:

Formula:

Please Login or Register  to view this content.

*Always press CTRL+SHIFT+ENTER to confirm entry after pasting or editing an ARRAY FORMULA in the Formula Bar.
When copying the formula to other cells, make sure the copied cell is not part of the Paste Area.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

Create a unique list with a count against the unique values

LinkBack

Thread Tools

Rate This Thread

Display

Create a unique list with a count against the unique values

Re: Create a unique list with a count against the unique values

Re: Create a unique list with a count against the unique values

Re: Create a unique list with a count against the unique values

Thread Information

Users Browsing this Thread

Similar Threads

Create unique # of worksheets based on list count with unique names

Count unique values and create list based on these values

Count unique values and create list based on these values

[SOLVED] Count unique values and create list based on these values

[SOLVED] Count unique values and create list based on these values

Count unique values and create list based on these values

[SOLVED] Count unique values and create list based on these values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions