Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Excel Manipulation

KaliRaj
Level 3

‎06-12-18 06:59 AM

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
0 Likes
2 REPLIES 2

AmiBarrett
Level 12

‎08-12-18 12:15 AM

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.
0 Likes

IrynaMilyanenka
Level 2

‎12-12-18 06:16 PM

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.
0 Likes