Using IF function to return to the cell

[Fankykwong93]

Hi, can I use the IF function to return to a cell?

For example, A1=ABC, A2=ABC, A3=XYZ, A4=DEF.

I want to know does it repeated by using IF Function.

In the cell B1, I input the formular as if it’s repeated, it will return “Repeated”, if it not, it will returned to the cell “A1”. And in the cell B2, if it not repeated, it will return to “A2” and so on.

Please give me a guide, thank you.

 

[FormR]

Hi, welcome to the forum!

Do you mean like this?

Excel 2013/2016
	A	B	C	D
1	ABC	ABC	XYZ	DEF
2	Repeated	Repeated	XYZ	DEF
Sheet1

Cell Formulas
Range	Formula
A2	=IF(COUNTIFS($A$1:$D$1,A1)>1,"Repeated",A1)

 

[AlanY]

you mean something like this?

Excel 2013/2016
	A	B	C	D
1	ABC	ABC	XYZ	DEF
2	Repeated	ABC	XYZ	DEF
Sheet3

Cell Formulas
Range	Formula
A2	=IF(A1=B1,"Repeated",A1)