How to write in cell with 2 conditions in excel?

Help Activities
, , ,
1

Hi,
I’d like to ask. how do you write in column E when the first 3 letters in column C contain “que” and the status in column D contains “D”. What activities should I use? Thank You.

Screenshot 2023-03-01 at 17.38.21
Screenshot 2023-03-01 at 17.38.21464×672 99.3 KB

2

In for each row in data table,
If CurrentRow(“Code”).ToString.Contains(“que”) and CurrentRow(“Status”).ToString.Contains(“d”) then

Assign CurrentRow(“Result”).Tostring = YourValueToWrite

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.