Hello

I'm looking for a way to find the relationship between the answers and participants.

Let me explain, I'm trying to look for similarities between the answers, if I find these similarities it most likely both participants share same concepts.


Untitled.jpg


This is an example of two questions, the 5 columns next to the questions start with (Strongly agree, agree, neither agree or disagree,....etc)

I'm trying to create a formula to see if responded 1 and 5 are somewhat similar in their answers across all the questions, is there a way that I could do this?

I've included a sample of my excel
Book1.xlsx
I truly appreciate anyone's help

Thank you