i have a scenario where i need to show in excel where one integer is lesser than 3 but greater than 1 … how do i do that ?
You can use For Each row loop and then you can use an If Condition
like if you have some Integer in a column as Number and status to update in other column like status
Then write as a condition as Cint(row(“Number”).ToString) > 1 and Cint(row(“Number”).ToString) < 3
then you can decide what to write in the status column
Hope this may help you
Thanks
Hi @poojaskyrathore
kindly find the below code instead of excel i have used build datatable …u can replace it with read range excel
Sequence1.xaml (8.4 KB)
hope this helps you
Thanks