Please help me with the 'Auto Fill Range' error

Help Studio
,
1

What would be a method to fill cells in column A based on the range of random values in column B? As shown in the current screenshot, the approach doesn’t seem to work. Thank you in advance!

image

2

Hi @22222222asas ,
Can you share input and expect result ?

1 Like
3

@Nguyen_Van_Luong1

image

The values in column B are always different

4

this is input?
and auto fill value in columnA?
what are output you want?

1 Like
5

@Nguyen_Van_Luong1

image

This is the desired output value.
The values in column B are always different
I hope for cell A to be filled in accordance with the values in cell B
thank you very much.

6

Hi,

Can you try the following sample?

image
image785×566 17.2 KB

Sample20230821-4L.zip (8.5 KB)

Regards,

1 Like
7

Hi @22222222asas ,
You can use auto fill in morden
image
with range A

1 Like
8

@22222222asas - Instead of "=C1 + B1" in the Write Cell activity, try:

"=C1 & B1"

This way, it is treated as String.

Hope this helps!

1 Like
9

@Yoichi
Doesn’t Auto Fill work within the Excel Application Scope?

10

@22222222asas
Does the value entered in A depend in some way on the value in B?
or simply A1–>An?
if need rules to fill, tell me about them

1 Like
11

Hi,

How about the following?

image

Sample20230821-4L (2).zip (9.0 KB)

Regards,

12

@Yoichi
thank you very much.
It’s solved!

1 Like
13

@Nguyen_Van_Luong1
thank you very much.

1 Like
14

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