Hi people,
I am getting confused with the IF, OR function. Would anyone help me on how to achieve below?
ITEM MTH STATUS
A JAN NO REFUND
A FEB REFUND
A MAR NO REFUND
B JAN NO REFUND
B FEB NO REFUND
B MAR NO REFUND
Return Item A as Refunded Item as long as there is a month with refund.
Item B as Non Refunded Item.
Thanks in advance
Bookmarks