<https://lh3.googleusercontent.com/-SvecRp6UIZU/VOfIbHUHuvI/AAAAAAAAATk/8uKivA68DVs/s1600/column2.jpg>
<https://lh6.googleusercontent.com/-FW_7oXRscLE/VOfIYLzqCSI/AAAAAAAAATc/H3a1eU3n9R8/s1600/column1.jpg> Guys, I'm not smart enough to figure this out, but I'd kiss the person who helps me figure this out. The goal is to compare four columns of numbers horiztonally and make sure they don't match the numbers in another four columns. So in the pics I've attached, I need to make sure that the section,row,rack, and u in any rows don't match the section row rack and u in the other four rows. The problem is that I have to recursively check that the section, row, rack and u does not match the section row rack and u in any of the rows, not just the same row. So for example if in Z3:AB3 I have 2 1 4 17 and in O5:R5 I have 2 1 4 17, I'd like to just know if they match. So any 4 sequential rows that match any other 4 sequential rows that match, I'd like to print something like "yes" or "No". -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
