dear expert
i have data which is need to consolidate by add new column values depends upon another column values
for e.g
In column G:G have True or False value i want TRUE value get result "FOLLOW ORDERS"in W:W column
Then
2nd condition In column P:P if cell values meet these 3 values then select blank cell in W:W
ZWACK get result as ZWACK in W:W
OPUS get result as OPUS in W:W
PANNERGY get result as RETURN_BD in W:W.
find the attachment
Bookmarks