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

 

[Desu Nota from Columbus]

Or would you need to use a macro to accomplish this?

 

[VoG]

What would trigger the macro? Changing A1?

 

[Desu Nota from Columbus]

Just clicking on Run macro or using a designated hotkey

 

[Desu Nota from Columbus]

And I believe I should clarify two things:


I only want to copy b1 to c1 if:
1. A1 is a duplicate and
2. B1 DOES NOT have an "s"

If A# is not a duplicate, I want it to be left unchanged.

I think I explained this poorly before.


I believe this would require 2+ IF statements.

=IF(AND((COUNTIF(A:A,A1)>1), B1="s"), C1="Y")
=IF(AND((COUNTIF(A:A,A1)>1), B1(doesn't equal)"s"), c1=B1)

 

[VoG]

I think it just requires this in C1 http://www.mrexcel.com/forum/showpost.php?p=2720729&postcount=4