Hi people, I have a data table with the following Column Names: Supplier / Value A / Value B / Value C I need to check if any sum of Value A + Value B + Value C is under a condition (such as sum less than 1.000). It could be from different suppliers, so a “for each row” is not the solution. Coul…

Thank you! I don’t only need the sums by row, I need every “threesome” of Value A + Value B + Value C, where the differents values could be from different suppliers. I solved by this method: 1)Creating three List for A, B and C extracting the values from the dataTable. 2)Setting a Do While with …

How to iterate over all the values of a table to check a condition

Help Automation Hub

sonnymeyer (Sonny) August 14, 2021, 11:27am 2

I think this may be what you are looking for

Topic		Replies	Views
For each row - if condition iteration issue, any alternative? Learn activities	2	1220	April 9, 2020
Loop data table Help excel , studio	3	2023	September 8, 2018
Check each data in datatable Help	6	862	May 10, 2019
Excel automation using for eachcolumn and check if row number 148 has value less than 5 Activities datatable , excel , question	5	205	August 26, 2023
For each value in column in excel Help datatable , excel , activities , question	10	1883	November 20, 2019

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

How to iterate over all the values of a table to check a condition

Related Topics