Tricky Process, requires some smart thinking. Check duplicates

[ppr (Peter Preuss)]

filter out the '@5C.... rows
and have a look on the FillUp_BlockBlanks.xaml

How to match data between 3 columns

when readin int the excel into a datatable (read range) we would expect following result Group1|1|true |2|True … so we would filling up the missing GroupX column values grouping the data on GroupDocs processing / evaluating the groups For filling up, have a starter help here: FillUp_BlockBlanks.xaml (9.3 KB) Grouping data have alook here:

When account 200004 is refering to the above rows: 2-13 from excel then we need to do some modification on the filling up. For this modification one of my colleagues @kumar.varun2 can help you