Mike Slattery
Board Regular
- Joined
- Dec 11, 2004
- Messages
- 101
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 col FW has the greatest value (whole number).
The catch is I don't know in advance if there will be two contingent matches or five or six? Very unlikely that there will be more than 8.
Thanks Michael
When I have multiple 1's I would like to check all of the Contingent cells containing 1's to determine which cell in col FW has the greatest value (whole number).
The catch is I don't know in advance if there will be two contingent matches or five or six? Very unlikely that there will be more than 8.
Thanks Michael
