Hi,
I need to remove or ignore the numbers where their each first and last condition is true for each number.If you see my below data 'BBB' and 'DDD' numbers first and last condition is true. Can anyone help on this?
Number | Condition |
AAA | TRUE |
AAA | TRUE |
AAA | FALSE |
BBB | TRUE |
BBB | TRUE |
CCC | TRUE |
CCC | TRUE |
CCC | FALSE |
DDD | TRUE |
DDD | TRUE |
Solved! Go to Solution.
Thanks for your response!
I almost got it. I still have small question here.
I am using this condition [First_Condition]==[Last_Condition].I want only both first and last condition is TRUE. There are some first and last condition is 'False'.Those numbers are converting into 'TRUE' if i use the formula [First_Condition]==[Last_Condition].
I need to ignore only [First_Condition]==[Last_Condition] ==''TRUE". Is there any way to implement this?
Maybe [First]=="TRUE" && [Last]=="TRUE"