Shrutiseth810
New Member
Hi All,
Am new to Blue Prism and don't any knowledge on writing macros.
I have a process in which input is an excel(input.jpg) file with company details (Company Name, Email Address, Postal Address, Bill No, Rejection Reason, etc.)
I have to get the number of occurrences for each Company and change format of column C to display bill nos correctly. Need to create Output.jpg
Manually I have created this by -
1) Sort column B (A-Z),
2) Add column D and use =COUNTIFS(B:B,B2,A:A,A2) and likewise
3) Change format of column C to display full Bill nos-> 2.99028E+11 becomes 299027911095
How can I do this in Blue Prism? Please help!
Thanks,
Shruti
Am new to Blue Prism and don't any knowledge on writing macros.
I have a process in which input is an excel(input.jpg) file with company details (Company Name, Email Address, Postal Address, Bill No, Rejection Reason, etc.)
I have to get the number of occurrences for each Company and change format of column C to display bill nos correctly. Need to create Output.jpg
Manually I have created this by -
1) Sort column B (A-Z),
2) Add column D and use =COUNTIFS(B:B,B2,A:A,A2) and likewise
3) Change format of column C to display full Bill nos-> 2.99028E+11 becomes 299027911095
How can I do this in Blue Prism? Please help!
Thanks,
Shruti