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