# Suggestions on if one cell value equals another cell value to insert a text in a new cell

#### bmkelly

##### New Member
I might talk in circles here but I will try to explain the best I cant.... I have a condition format in column AJ for duplicates to make text red.... What I want to do now is in the next column I want to mark a Y or N for reviewing purposes. I feel like the answer can be so simple but I dont think its as simple as what my brain is trying to tell me.... What formula can I use here?

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### Joe4

You can use a COUNTIF formula to count how many times the value in that row appears, and if it is more than once, return "Y", i.e.
put this formula in cell AK5:
Code:
``=IF(COUNTIF(AJ:AJ,AJ5)>1,"Y","N")``
You can then copy that formula down for all rows.

#### bmkelly

##### New Member
You can use a COUNTIF formula to count how many times the value in that row appears, and if it is more than once, return "Y", i.e.
put this formula in cell AK5:
Code:
``=IF(COUNTIF(AJ:AJ,AJ5)>1,"Y","N")``
You can then copy that formula down for all rows.
Thank you!!!!! I couldn't think for the life of me how to do this even though I knew in my brain its possible

#### Joe4

You are welcome.

Hopefully, now that you see it, it makes sense.
If not and you have any questions, let me know.

Replies
7
Views
257
Replies
1
Views
55
Replies
3
Views
63
Replies
7
Views
120
Replies
14
Views
82

1,127,538
Messages
5,625,397
Members
416,100
Latest member
lirongr1996

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back