How can you word this statement?

[Desu Nota from Columbus]

I am trying to write an If statement:

If any cell in column A equals or matches another cell in column A.....blah blah blah.


The values in Column A are numbers but they could potentially be text/date etc... There can be an infinite amount of duplicates (but there wont be).

Ex. If A1 = (any other cell in Column A), perform F(x).
If A5 = (any other cell in Column A), perform F(x).

I know how to write the end part of the if statement, but I don't know the beginning.

HELP ME!!

Thanks

 

[VoG]

Try

=IF(COUNTIF(A:A,A1)>1,"found","not found")

 

[Desu Nota from Columbus]

First off, thank you for the response.

I got that to work i believe. Is my thinking correct below?

Now this says,

if A1 is a duplicate of any other cell in column A AND b1 has an "s"....

=IF(AND((COUNTIF(A:A,A1)>1), B1="s"),


How do I get this to do the following:

put a Y in C1 if true

copy b1 to c1 if false

 

[VoG]

Try

=IF(AND((COUNTIF(A:A,A1)>1), B1="s"), "Y",B1)

 

[Desu Nota from Columbus]

One last caveat, this formula isn't going in column C, so i believe just putting "Y" and B1 won't work. Is there a way to specifically change them through this if statement?

 

[VoG]

I don't understand.

 

[Desu Nota from Columbus]

I'm known to have senior moments... lol.


Thanks for the help I forgot what I was doing for a moment.

 

[VoG]

I think I've lost the plot, sorry.

 

[Desu Nota from Columbus]

I think I've lost the plot, sorry.

I guess i am wondering if you can put this IF statement into Column AZ, and make it change Column C?


For this to be possible I believe the end of this formula (in blue) would have to explicitly state:

set C1="Y"------(for True), set c1=b1------(for false)


=IF(AND((COUNTIF(A:A,A1)>1), B1="s"), "Y",B1)

 

[VoG]

No, the formula would need to go in column C. What is the problem with doing that?