If formula

[eramirez148]

How can I get the results in column "C". If the values in column "A" are repetitive then I want the values in column "B" to only appear one time in column "C"

	A	B	C
1​	22222​	10​	10​
2​	22222​	10​
3​	22222​	10​
4​	33333​	10​	10​
5​	33333​	10​
6​	33333​	10​
7​	44444​	20​	10​
8​	44444​	20​

 

[eramirez148]

How can I get the results in column "C". If the values in column "A" are repetitive then I want the values in column "B" to only appear one time in column "C"

	A	B	C
1​	22222​	10​	10​
2​	22222​	10​
3​	22222​	10​
4​	33333​	10​	10​
5​	33333​	10​
6​	33333​	10​
7​	44444​	20​	20​
8​	44444​	20​

 

[dreid1011]

You can try this:

=IF(COUNTIF($A$2:A2,A2)=1,B1,"")

 

[Peter_SSs]

If I have understood correctly then even simpler would be ..

24 10 05.xlsm
	A	B	C
1
2	22222	10	10
3	22222	10
4	22222	10
5	33333	10	10
6	33333	10
7	33333	10
8	44444	20	20
9	44444	20
Once

Cell Formulas
Range	Formula
C2:C9	C2	=IF(A2=A1,"",B2)