How to flash fill the number series

how to flash fill the number series in excel by using modern activities.how to auto increment the numbers

@anjani_priya

Assign startingNumber = 1

Use For each loop

For Each num in Enumerable.Range(1, 10) // Change the range as needed

Assign startingNumber = startingNumber + 1

Hi @anjani_priya

Regards

Range should be dynamic
there is a column beside sno. The numbers should fill based on the range of beside column

I have used this but not working

Hi @anjani_priya

Hope it helps!!

Hi @anjani_priya

Please check the below flow:

Regards

@anjani_priya

Read range the excel
in for loop

For Each num in Enumerable.Range(1, DatatableName.Rows.Count)
Then it will get the range of your excel rows

I have done the same but iam getting all 1’s

Hi @anjani_priya
Check this

Hi @anjani_priya

Try this
Test.zip (2.8 KB)

Happy Automation :slight_smile:

no iam getting in the single cell

@anjani_priya

Can you send the input and expected output

Hi @anjani_priya

Can you share the required Input and the output.

Regards

Book 1.xlsx (10.1 KB)

@anjani_priya


Hi @anjani_priya

Give Counter value as 2


Book 1.xlsx (10.1 KB)
Main.xaml (13 KB)

Regards

@anjani_priya

Try this
Test.zip (2.7 KB)

Its not getting at the desired index

HI @anjani_priya

Have you checked this?

Regards