Excel Manipulation

[KaliRaj]

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

[AmiBarrett]

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.

[IrynaMilyanenka]

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.