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

	A	B	C	D
1	1200
2	1500
3	1200
4	1700
5	1200

<tbody>
</tbody>

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

	A	B	C
1	1200	True
2	1500	True
3	1200	Already Exist
4	1700	True
5	1200	Already Exist

<tbody>
</tbody>

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?