How do I compare two rows of data?
I have been trying to create a function in numbers and getting stuck.
I have a spreadsheet that contains a column of scenes, and a character in each row. The corresponding cells are filled with true and false (whether a characteristic in the scene or not).
I want to compare the data to find:
1) compatible scenes that can rehearse simultaneously without missing any characters. The resulting a spreadsheet would look like an old time stable, where the scenes would be listed in both column header and row header.
I need a formula that compares two whole rows:
=IF(any Cell in rowX is not equal to its counterpart in rowY, "X","Compatible"
*It would be even better if X and Y were relative - but Can you make a reference that says $B(ROW()):$W(ROW())=$B(COLUMN()):$W(COLUMN()). ?
iPhone 5, iOS 6, at and t