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

bmkelly

Board Regular
Joined
Mar 26, 2020
Messages
172
Office Version
  1. 365
Platform
  1. Windows
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?


1610993653977.png
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
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.
 
Upvote 0
Solution
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 :ROFLMAO:
 
Upvote 0
You are welcome.

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

Forum statistics

Threads
1,213,532
Messages
6,114,176
Members
448,554
Latest member
Gleisner2

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top