Compare a variable with an array list

[Tedskayteur]

Compare a variable with a variable that has several array values

 

[webalchemist]

You will need to create a macro like:

For each (array[variable])
If variable = array[variable]
Do something

And you could add
If variable != array[variable]
Do something else

 

[Tedskayteur]

Thanks but is it possible to browse all the values of an array exmple in a condition if it finds a value that corresponds to a variable the action is

 

[webalchemist]

I'm pretty sure that's what the example I gave you does.

Can you maybe describe it a different way?

 

[Tedskayteur]

In the example you have given I have the impression that we are comparing one value of the table whereas I want to compare all the values of my table, e.g. if my table contains 3 values



Instead of specifying







My variable :







Invariant = 20







My array







array [1]= 10



array [2]= 20



array [3]= 30







I want to search for the value corresponding to 20 in the array without specifying its rank

 

[Endercraft]

 

[Tedskayteur]

Merci beaucoup je vais essayer de postuler

 

[Endercraft]

Merci beaucoup je vais essayer de postuler

Anglais ici svp

 

[webalchemist]

In the example you have given I have the impression that we are comparing one value of the table whereas I want to compare all the values of my table, e.g. if my table contains 3 values


Instead of specifying

My variable :

Invariant = 20

My array
array [1]= 10
array [2]= 20
array [3]= 30

I want to search for the value corresponding to 20 in the array without specifying its rank

In the example I gave the magic is in the for statement... for each value in array, do the action...

So that means, it will process every value and do your function.

So it will process array 1 then array 2 then array 3.

let us know if between this and Ted's post you have all you need or if its still unclear.

you can upload your macro here for us to have a look if you still need more help

 

[Tedskayteur]

I found a way to automatically insert the numbers in a table but I don't want the number to be recognizable so I wanted to compare the values in the table before inserting but even with your method it doesn't work for me

 

[Tedskayteur]

View attachment 3736
View attachment 3737

Thank you very much, it went really well, thank you

 

[webalchemist]

Glad it worked for you! Thanks for letting us know!