Identify Unique Value Only

[Rahulwork]

Hello Everyone,

Hope you are fine.

I have a spreadsheet and there is a column contain duplicate value. Pls find below for example


[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1700[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I need a formula in B1 where result should be like below:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[/TR]
[TR]
[TD]

[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1200[/TD]
[TD]True[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1500[/TD]
[TD]True[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1200[/TD]
[TD]Already Exist[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1700[/TD]
[TD]True[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1200[/TD]
[TD]Already Exist[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I want duplicate should be count once. Pls help

Let me know if you need any further information.

Regards
Rahul

 

[Aladin Akyurek]

In B1 enter and copy down:

=IF(COUNTIFS($A$1:A1,A1)=1,TRUE,"Already Exist")

 

[Eric W]

Then to count the unique numbers, you can use this:

=COUNTIF(B:B,TRUE)

There are more complicated formulas that can calculate the number of unique items without the B column.

 

[Rahulwork]

Perfect. that's what i want

 

[Aladin Akyurek]

Perfect. that's what i want

And that is?

 

[Rahulwork]

Hi.. No

I mean i m getting the same result but while m doing pivot on value and taking True count it's still including already exists one as well

Help

 

[Aladin Akyurek]

Hi.. No

I mean i m getting the same result but while m doing pivot on value and taking True count it's still including already exists one as well

Help

What are you up to? Obtain a unique count?