When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be OR

Dear Folks,

I am working on huge amounts of data, where i have to find out incorrect condition in between records.

Col-a Col-b Col-c Col-d Col-e Col-f
AUTH_ASSISTANT SAP_R3_LG S_USER_AGR ACTVT 01 AND
AUTH_ASSISTANT SAP_R3_LG S_USER_AGR ACTVT 02 AND

Conditon :
When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be OR condition

but in my huge data set this condition went wrong and values are filled with AND. Now i need to find/mark records which have AND value in Cpl-f when record met with condition above. I am not able to do this in pivot or any vlookups, concat etc..

See attached sample data.

Any ideas to how to deal with this.

Regards,
Jay