Is there a good method of storing a list of rows in a cell and then detecting whether a certain row is in that list?
The method I have seems a bit over the top. I label each row with a prime number, then store the list of rows as the product of each prime, missing out the rows I don't want in my list.
Detecting whether a given row is in the list is then simple: just see whether a given prime divides the product of primes without remainder.
Here's a spreadsheet with labels.
Update: I've completely rewritten this question to be clearer as it was getting calls for closure. Please comment if you have a view.