Formula to find if string exists in different cell within same column

Hi,
I have a spreadsheet with a column of IDs that I need to find if strings of text exist in a different cell within the same column. Individual cells may contain a single ID or may contain multiple IDs. For example:

ABC-41796 |ABC-41958
ABC-41796

I cannot use Conditional Formatting > Highlight Duplicate Cell Values because only a portion of the cell may be duplicated. I've tried several different formulas such as XLOOKUP, IF(ISNUMBER), IF(COUNTIF), SEARCH with no success. Any help would be greatly appreciated.

I also am unable to upload attachments for whatever reason.

Below is the full example:

ID Exists
ABC-41953 |ABC-42383 N
ABC-41303 |ABC-42081 N
ABC-41796 |ABC-41958 Y
ABC-41566 |ABC-41850 Y
ABC-39701 N
ABC-41796 Y
WXYZ-6609 N
ABC-41566 Y

Thank you.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

For your values starting in cell A2, use conditional formatting with the Formula option, with the formula

=MAX(COUNTIF(A:A,"*"&TEXTSPLIT(TRIM(TEXTSPLIT(LEFT(A2,LEN(A2)-2),"|"))," ")&"*"))>1

and choose your fill.

OR - fill a column with that formula to match your data, then filter to show TRUE values only. Note that there may only be one of the multi-entries in a cell that is duplicated.....