Hi All, In the following table I'm trying to find the value in three consecutive ID's, sample data ID Name 1 AGB 1 AGB 1 CONN 1 BGCA 2 AGB 2 CONN 2 CAZ 3 CONN 3 CAZ 3 AGB 3 JRSC 4 ABM 4 ABM 4 BACO 4 AGB 4 HFC 5 BACO 5 HFC 6 BACO 6 JKB 7 HFC 7 BACO 7 JKB Thanks for the help.
... View more