Hi Some time I got status Open and some time Open Rec.I just want if status is open Rec then it consider status as Open.As mention in attachment.
do you want to check for two lines 1, 2
or for 1 alone
and did we try to use DATA SCRAPPING that would give us the value even indatatable format
no want only in one.
eg consider this as one row if I got status is Open Rec.Then it consider open rec as open