Formula to count unique possible?

Hi,

I have data like this:

ID8899 - Apple - 5.99$
ID8899 - Apple - 5.99$
ID7788 - Banana - 4.99$
ID8899 - Apple - 5.99$
ID8899 - Apple - 5.99$
ID7788 - Banana - 4.99$
ID8899 - Apple - 5.99$

I want to be able to add a column D and using a formula to only add the number 1 to the first one that is unique.

ID8899 - Apple - 5.99$ - 1
ID8899 - Apple - 5.99$ - 0
ID7788 - Banana - 4.99$ - 1
ID8899 - Apple - 5.99$ - 0
ID8899 - Apple - 5.99$ - 0
ID7788 - Banana - 4.99$ - 0
ID8899 - Apple - 5.99$ - 0

I can use pivot table to only list unique data result, but the problem with pivot table is that we cannot add comment. So I am looking a way to generate the same result as Pivot Table, but being able to add a column to add "Comment".

Any solution?

Thanks

Thanks, if I just copy paste the formula it works. But my data is stored in a table and has header.
How the formula works?

Please Login or Register  to view this content.

But it doesn't work.

You can use this formula on column D to achieve this.

Please Login or Register  to view this content.