How to number the item in excel (containing repeat)

Help Studio
1

Hello everyone, thanks for help.

I have a serial number problem that I want to number the item ,

but it’s not just serial number. like this image .

Three item (X Y X in column C) , because item doest emerge just once ,

so I need to use line item(column B) to count the item.

Serial number will be the same in same item(column A)

I want to use UiPath to generate column A and column B. Thanks

image

serial number.xlsx (9.9 KB)

2

Did not understand well
Can you tell me what you want to print?

3

@yundw
thanks for your reply immediately.

I want to print column A and column B

before
image

after

image

4

Hi @lojyehuang,

you need to print Line item and Serial number based on the item right
Can i know the source of data ? where u getting the data and what include in it ? then we can read that data and based on that data we can build the logic how to read and write in the excel outcome you want

5

HI @SamanGuruge

The thing I have just the excel . Now I can solve this problem by invoke VBA and write formula in the excel .
Look at this . But I want to use Uipath to solve this problem, too. Thanks!

image
image769×284 5.35 KB

image

6

Hi @lojyehuang.

Now understood Luckily you can do this using UiPath.
just you need to pass Items as source
give me a moment i’ll post you a sample project

7

@SamanGuruge
Share! I also want to know how to solve this problem without VBA !
Main.xaml (6.4 KB) vb_serialnumber_ansi.txt (1.4 KB)

8

@lojyehuang
find some starter help here:
Count_GroupIds-GroupItem_1Col.xaml (10.6 KB)
running with this Excel:
Items.xlsx (9.7 KB)

I Just adopted some names (Column, Worksheet), but feel free to modify it by your needs.

Let us know your feedback

1 Like
9

test_1.zip (26.6 KB)

1 Like
10

@ppr
Thanks!! this is what I want!!

11

Thanks @yundw this works fine

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.