What is the most efficient way to check adjacent cells for similarities. I have a flag in col FY that indicates if a record repeats. The flag is a 1 for True and a 0 for False.
When I have multiple 1's I would like to check all of the Contingent cells containing 1's to determine which cell in...