I have four columns that are filled up by SL and JT. I need to do an analysis to calculate the similarity of categories SL and JT have in common. I want to show this similarity in percentage. For example, first row is 0 as none of the values match up. Second is 50% as we have 7's matching. same logic is for third row and for fourth, it is 0. Could you please suggest the formula that can automate the similarity?
| Primary Category (SL) | Primary Category (JT) | Secondary Category (SL) | Secondary Category (JT) | first and second category analysis |
| 6 | 7 | 2 | | |
| 7 | 7 | | | |
| 1 | 1 | | | |
| 6 | 5 | 3 | | |
