Count Multiple entries as one

[msgjazz]

I have names in a column that may repeat and dates associated to those name that also may repeat. I'm trying to summarize them by date

7/20/2016 McKoy, Rick
7/20/2016 McKoy, Rick
7/20/2016 McKoy, Rick
7/20/2016 McKoy, Rick
7/20/2016 McKoy, Rick
7/20/2016 Smith, Sam
7/20/2016 Smith, Sam
7/29/2016 Smith, Sam
7/29/2016 Smith, Sam
8/2/2016 Cutler, Jen
8/2/2016 Hoover, Dam
8/9/2016 Hoover, Dam

With the above date I need something like the following

7/19/16

7/20/16

7/29/16

8/2/16

8/9/16

McKoy, Rick

0

1

0

0

0

Smith, Sam

0

1

1

0

0

Cutler, Jen

0

0

0

1

0

Hoover, Dam

0

0

0

1

1

I don't need a count, but just that on that day the name appears at least 1 time

I tried doing IF AND statements but get #Values.

Thanks

Sorry for the way it looks. Not sure how to paste as table

[Pete_UK]

It would help if you attached a sample Excel workbook, and then we can see your data more clearly you can explain within the file what it is that you want to achieve.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

[Glenn Kennedy]

Here's one way (array formula):
=SUM(IF(FREQUENCY(IF($A$1:$A$12=H$1,IF($B$1:$B$12=$G2,$A$1:$A$12)),IF($A$1:$A$12=H$1,IF($B$1:$B$12=$G2,$A$1:$A$12)))>0,1))

Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

[msgjazz]

Thanks. I have these instruction saved for the next post.

[msgjazz]

This worked beautifully, thanks

[Glenn Kennedy]

You're welcome.