Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...
When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count unique distinct values that meet multiple date criteria

Thread starter AV114
Start date Feb 26, 2020

A

AV114

Member

Feb 26, 2020

#1

How to count unique distinct values that meet multiple date criteria

N

Nashraze

New Member

Mar 1, 2020

#2

Dear AV114,
its very simple formula =countif(B2:B41,"Rajesh.A")

F

Fluff13

Active Member

Mar 1, 2020

#3

If you have the dynamic arrays
=COUNT(UNIQUE(FILTER(INT(A2:A41),B2:B41=E4)))

F

Fluff13

Active Member

Mar 1, 2020

#4

Alternatively
=SUM(--(FREQUENCY(IF(B2:B41=E4,INT(A2:A41)),INT(A2:A41))>0))
This needs to be confirmed with Ctrl Shift Enter, not just Enter

You must log in or register to reply here.

Share:

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Top