Excel | Community

How to take from Excel all values SA, AB, DA from column A that are not empty in column G, that are negative values in column J

Page 2 / 2

solved the problem, via the if else function here is the robot I am working on

Great job!

Thank you teacher for your help!!!!? ?

How to insert obtained dynamic data relative to static variable in Excel

Hi, I'm not sure what you mean. Are you asking how to insert Excel formulas?

don't understand how to add data to static data by numbers from dynamic data

Still not quite clear, but based on what I see and your arrows you are trying to:

For each number in column B, find the same number in column J, and move the matching number in J to the same row as the number in column B

Is that right?

Yes ,this is true)

Ok, here is some sample LWIZ code that does what is described above. You can see that the values on the right are now aligned with those on the left.

Before:

After:

And the sample Excel used with it. I hope this helps

Interesting implementation, I will study, thanks teacher,

how to open lwiz files I'll leave here

Sign up