MossyPants
New Member
- Joined
- May 21, 2022
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
I am looking for a way to find identical rows across three columns.
My worksheet looks similar to this:
I would like to find matching rows (A&B&C), and if there is a duplicate, I would like the word "Duplicate" to appear in that row in column D.
I hesitate to put any conditional formatting in columns A-C because they will be frequently copied&pasted into and out of, and I don't want to worry about messing up the formatting.
I'd like a formula for column D that would essentially remain invisible except to display the word "Duplicate" if necessary.
Ideal output:
I feel like COUNTIF might be what I need, but I can't quite figure out how to use it to do what I want.
My worksheet looks similar to this:
I would like to find matching rows (A&B&C), and if there is a duplicate, I would like the word "Duplicate" to appear in that row in column D.
I hesitate to put any conditional formatting in columns A-C because they will be frequently copied&pasted into and out of, and I don't want to worry about messing up the formatting.
I'd like a formula for column D that would essentially remain invisible except to display the word "Duplicate" if necessary.
Ideal output:
I feel like COUNTIF might be what I need, but I can't quite figure out how to use it to do what I want.