Dealing with complex IF formulas

Formulas in attached file do not work, because they have links to the external files, like

Formula:

Please Login or Register  to view this content.

etc. Which we obviously cannot access.

I know. The idea is to address the comments without the additional file. If I send the additional file it will not help as you would have to redo the formulas.

I've got no time to create dummy file to test.
So from my side proposition to deal with "customer only" records without adding hyphen - D8:

Formula:

Please Login or Register  to view this content.

and E8 without CHAR(20) (which is apparently line break character used in your csv - standard would be rather char(10) "Line Feed" or char(13) "Carriage Return", because formally char(20) is a "Device control 4")

Formula:

Please Login or Register  to view this content.

Perhaps this will be of some help.
On the Source data sheet
The Original silo column is populated using:

Formula:

Please Login or Register  to view this content.

The Original team column is populated using:

Formula:

Please Login or Register  to view this content.

The Date received column is populated using:

Formula:

Please Login or Register  to view this content.

The OK column (formatted wingdings 2) is populated using: =IF(OR(E2<>F2,G2<>H2,I2<>J2,K2<>L2),"O","P")
On the Results sheet B22:L23 are populated using:

Formula:

Please Login or Register  to view this content.

The Issue column is populated using:

Formula:

Please Login or Register  to view this content.

I'll look at the top of the results sheet later if someone hasn't already given a solution.
Let us know if you have any questions.

Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!

Originally Posted by JeteMc

Perhaps this will be of some help.

You really have helped!

Wow! I'm so grateful!

Can you look at the results sheet? No one else has responded yet.

It would help us if you would manually put your expected outputs, based on the source data, in the appropriate cells so that we will have something to base our formulas/code on.
Let us know if you have any questions.

As mentioned in post #7, Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.