Criteria for two of the same text in 2 different columns

[Fredbugatti]

I need a formula or macro which will not let me put 2 of the same text in 2 different columns for example column A line 2"Apple" Column B Line 2 "Apple" it will not go in sheet.

[Richard Buttrey]

This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.


To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.Hi,

[Fredbugatti]

Sure, please see attached there are apples in a3 and b3 so if they match then it should not let me input at all.