Identify

[richmcgill]

I need help.
In this example, the Account number is constant. I am looking for duplicates.
I need to identify if the account number is on here more than once.
The description dates match (the words do not matter)
Gives me a result of Delete for the persons ID of AABB.
Person CCDD would be "Okay"
If there is not a match or duplicate it should read "Okay"
Make sense?
Any help is appreciated.

Account Number	Person	Description	Solution or Desired Results
123456789	AABB	Changed 05/01/24	Delete
123456789	AABB	Changed 05/15/24	Delete
123456789	CCDD	Corrected 05/01/24	Okay
123456789	CCDD	Corrected 05/15/24	Okay

 

[Eric W]

Assuming the date is always on the right:

Book1
	A	B	C	D
1	Account Number	Person	Description	Solution or Desired Results
2	123456789	AABB	Changed 05/01/24	Delete
3	123456789	AABB	Changed 05/15/24	Delete
4	123456789	CCDD	Corrected 05/01/24	Okay
5	123456789	CCDD	Corrected 05/15/24	Okay
Sheet5

Cell Formulas
Range	Formula
D2:D5	D2	=IF(AND(COUNTIF($C$2:$C$5,"*"&TRIM(RIGHT(SUBSTITUTE(C2," ",REPT(" ",99)),99)))>1,NOT(B2="CCDD")),"Delete","Okay")

 

[richmcgill]

Assuming the date is always on the right:

Book1
	A	B	C	D
1	Account Number	Person	Description	Solution or Desired Results
2	123456789	AABB	Changed 05/01/24	Delete
3	123456789	AABB	Changed 05/15/24	Delete
4	123456789	CCDD	Corrected 05/01/24	Okay
5	123456789	CCDD	Corrected 05/15/24	Okay
Sheet5

Cell Formulas
Range	Formula
D2:D5	D2	=IF(AND(COUNTIF($C$2:$C$5,"*"&TRIM(RIGHT(SUBSTITUTE(C2," ",REPT(" ",99)),99)))>1,NOT(B2="CCDD")),"Delete","Okay")

That works awesome!!!!

Thank you for the help!

 

[Eric W]

Happy to help!