#### Harry Flashman

##### Active Member

- Joined
- May 1, 2011

- Messages
- 361

**Excel 2010**

A | B | C | |
---|---|---|---|

Media | Date | Circulation | |

Newspaper_02 | |||

<tbody>

[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="bgcolor: #D9D9D9"]Newspaper_01[/TD]

[TD="bgcolor: #D9D9D9, align: right"]1/01/2014[/TD]

[TD="bgcolor: #D9D9D9, align: right"]1000[/TD]

[TD="align: center"]3[/TD]

[TD="bgcolor: #D9D9D9"]Newspaper_02[/TD]

[TD="bgcolor: #D9D9D9, align: right"]2/01/2014[/TD]

[TD="bgcolor: #D9D9D9, align: right"]1000[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]2/01/2014[/TD]

[TD="align: right"]1000[/TD]

[TD="align: center"]5[/TD]

[TD="bgcolor: #D9D9D9"]Newspaper_02[/TD]

[TD="bgcolor: #D9D9D9, align: right"]3/01/2014[/TD]

[TD="bgcolor: #D9D9D9, align: right"]1000[/TD]

[TD="align: center"]6[/TD]

[TD="bgcolor: #D9D9D9"]Newspaper_03[/TD]

[TD="bgcolor: #D9D9D9, align: right"]5/01/2014[/TD]

[TD="bgcolor: #D9D9D9, align: right"]1000[/TD]

</tbody>

The sum of circulation values above is 5000.

The

**unique circulation**is 4000.

Notice that Newspaper_02 appears on three three rows, but the second row does not count because it has the same date (each row represents a newspaper article, on January 2nd Newspaper_02 had two articles. The circulation for the second article does not count because it occurred in the same issue as the first article.

I want to calculate the unique circulation with a single formula, if this is possible. If it is not possible I have other ways, but I would like to find out if there is a way of doing with a single formula.

Do any of you Excel geniuses out there see a way that this might be achieved? I would greatly appreciate any help with this. Cheers.