Blimey John. That takes me back. Used to do a lot of that sort of work. Didn't half save time.

Here is a simplified example of the set up in Excel, having copied the paragraphs across, and given each row a number, sorted and then put the formulas in column C

1        One to One                                      
3        One to One      =IF(B1=B2,1,0)
8        One to One      =IF(B2=B3,1,0)
2        One to Two        =IF(B3=B4,1,0)
4        One to Two        =IF(B4=B5,1,0)
7        One to Three        =IF(B5=B6,1,0)
5        One to Four        =IF(B6=B7,1,0)
9        One to Five        =IF(B7=B8,1,0)
6        One to Five        =IF(B8=B9,1,0)

Note that you do not need a formula in row 1.
I have kept the text in column B simple as it is easier to understand as an example.
The result does not take into account case sensitive issues

Hope that helps