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

bmkelly

New Member
Joined
Mar 26, 2020
Messages
10
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
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,649
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Mar 26, 2020
Messages
10
Office Version
  1. 365
Platform
  1. Windows
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:
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,649
Office Version
  1. 365
Platform
  1. Windows
You are welcome.

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

Watch MrExcel Video

Forum statistics

Threads
1,127,523
Messages
5,625,308
Members
416,090
Latest member
Amneziak

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
Top