countinfs with 2 criteria, need to add non duplicated count

**MarvinP** · 12-21-2014, 02:08 PM

Hi Mark,

We really need a sample workbook to see to solve this. You can attach a sample by clicking on "Go Advanced" and then the Paper Clip Icon above the advanced message box.

Will you allow a "Helper Column" to be added to the data?

**Mark_Delaware** · 12-21-2014, 02:29 PM

Basically the answer I need from the sample sheet is 3, but my formula shows 4. One name is counted twice, I want a count of "y" based on column C not being blank (I changed my question to match the sample sheet attached)and non duplicated names from column B

I hope this isn't clear as mud

countinfs with 2 criteria, need to add non duplicated count

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: countinfs with 2 criteria, need to add non duplicated count

Re: countinfs with 2 criteria, need to add non duplicated count

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] count duplicated string in Range for each letter,Non Adjacent Row

VBA Macro to create subtotals based around criteria - some of this criteria is duplicated

[SOLVED] delete duplicated rows based on a criteria in another column

Question: Count Unique/Duplicated 5 number Combination

I need to count how many times a name is duplicated?

Bookmarks

Bookmarks

Posting Permissions