How to only count duplicates once without removing duplicate data

[Demona26]

Hi All. I'm hoping someone can help.
I have a column of data that has duplicates. I do not want to remove duplicates as I still need the information in those rows for a sum count of the price, but I do need to identify 1 of each duplicate value in another column. So, I need the end result to look like this:

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Opportunity Number
[/TD]
[TD]Unique Count
[/TD]
[/TR]
[TR]
[TD]O-015752
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]O-015752
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]O-015752
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]O-15555
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]O-15555
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]O-98587
[/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]

I have tried Conditional Formatting, with a =a1=a2 formula, but it doesn't seem to pick up all the values as some of the opportunity numbers can have up to 10 rows, and then manually enter the unique count based on color, but it doesn't sort it properly (some Opportunities are highlighted multiple times, or not at all.

Please note that I do not know VBA at all. (Some of you may recognize this is out of Salesforce - I know I can run a different type of report to only count opportunities, but I need it to do this from Excel)

Any Suggestions?

 

[lrobbo314]

How about this?

=(COUNTIF($A$2:A2,A2)=1)+0

 

[Demona26]

OMG that worked! Thank you so much. This has been bugging me all day!