https://community.blueprism.com/t5/Product-Forum/Excel-Manipulation/m-p/84745#M35842 There should be an action in the VBO called ""Get Worksheet Range As Collection"". If the tables change in length, but have a static offset between them, you can dynamically figure out the positioning using the Find Next Empty Cell action. Sat, 08 Dec 2018 00:15:00 GMT AmiBarrett 2018-12-08T00:15:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Manipulation/m-p/84744#M35841 Hi Al, I am having excel with below data . Please find attachment for the same. Rules : 1. Title = ADD  2. Custom String 2 = Email 3. Role = Need to group By Custom String 1 and find the occurrence Please find attachment for Input and Output How to achieve this in Blue Prism. Thanks, Kali Raj p Thu, 06 Dec 2018 06:59:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Manipulation/m-p/84744#M35841 KaliRaj 2018-12-06T06:59:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Manipulation/m-p/84745#M35842 There should be an action in the VBO called ""Get Worksheet Range As Collection"". If the tables change in length, but have a static offset between them, you can dynamically figure out the positioning using the Find Next Empty Cell action. Sat, 08 Dec 2018 00:15:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Manipulation/m-p/84745#M35842 AmiBarrett 2018-12-08T00:15:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Manipulation/m-p/84746#M35843 I can suggest to insert the formula =COUNTIFS($C:$C;$C2;$B:$B;$B2;$A:$A;$A2) in the column next to Custom String 2 to get the Role number for the row.  Then you can insert the formula =IF(A2=A1;IF(B2=B1;IF(C2=C1;1;0);0);0) in the column next to the Role column to get rid of duplicate values (0 is the first occurrence, 1 is a duplicate). Then filter by Title (""ADD""), Custom String 2 (""Email"") and the last calculated Duplicate Column (0) to get the desired output. To do this with Blue Prism, you can use the MS Excel VBO actions (Set Cell Value, Copy Range, Select) If there's no filter action in MS Excel VBO, you can create your own using the VB.NET method Range.AutoFilter. Wed, 12 Dec 2018 18:16:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Manipulation/m-p/84746#M35843 IrynaMilyanenka 2018-12-12T18:16:00Z