Hi, I have the following data AB 11 22 33 41 52 63 74 I want to write a macro which takes the value from B and filter A, then multiply them and store it in subsequent columns. The output I want is amultiplier 111 23 4 222 46 833 3 69 12444 8 12 1655 510 15 2066 6 1218 2477 7 14 2128 when I tried in batch macro using control parameter , update value as shown below I get the following result. ab 1112243394416552566367749 Can some one please help me on what is wrong with the flow.

Macro for filter values and save it as different results

Hi,

I have the following data

A	B
1	1
2	2
3	3
4	1
5	2
6	3
7	4

I want to write a macro which takes the value from B and filter A, then multiply them and store it in subsequent columns.

The output I want is

a	multiplier
1	1	1	2	3	4
2	2	2	4	6	8
3	3	3	6	9	12
4	4	4	8	12	16
5	5	5	10	15	20
6	6	6	12	18	24
7	7	7	14	21	28

when I tried in batch macro using control parameter , update value as shown below I get the following result.

a	b
1	1	1
2	2	4
3	3	9
4	4	16
5	5	25
6	6	36
7	7	49

Can some one please help me on what is wrong with the flow.

Topic of Interest

Accepted answers

AdamR_AYX

Does the attached do what you are looking for?

MultiplierParent.yxzp

AdamR_AYX

You certainly can. See the attached. You might want to clean up what fields go into the excel file, but it should give you the idea.

MultiplierParent.yxzp

All comments

StephenRuhl

Looks like you want an iterative macro. I have a couple of questions: In the output example it looks like Column A was just added to the result each time. In the batch macro example it looks A and B are multiplied, but the pattern on B is not the same as the top input data, is what you want Column A multiplied by Column B? Finally, how many times do you want this multiplication to happen?

Manojkumar

Hi Sruhi,

Thanks for replying. Yes, I want the column A to be multiplied with column B values.

About how many times, its the number of values in column B. Lets say, first take column B value 1, multiply all the values of A with 1.

Then take the second value of column B which is 2, multiply all the values of A with 2. Like this do for all values in column B.

Hope I have clarified. kindly let me know if you need more info.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703