Count per unique dates and names

[ElmerS]

Hi,

The question is presented and explained within the attached WB.

Thanks, Elm

[NBVC]

Try, In B21:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and not just ENTER, then copied down

[ElmerS]

Hi, NBVC,

I figured it out myself and the formula hereunder is a little bit shorter:

Please Login or Register  to view this content.

Thanks anyway, Elm

[NBVC]

Yes, yours works in this case (numeric values in column A)....

mine, although longer and more complex, is adaptable to both numeric entries in column A and text entries in column A..

[ElmerS]

Good to know and to learn.

Thanks again, Elm