I need to perform a check to find out how many pairs of seats exist on a given performance. I can't do just a seat count because individual seats on opposite sides of the theatre are not desired. Here is a link to an image of the seat configuration and attached is a spreadsheet with the columns we have to work with:
Note: The spreadsheet is the data related to the image provided.
I am having trouble figuring out a way to determine seats that are next to each other. Thanks for the help!