Hello,
I have an AND / OR function in which I have at least 12-15 arguments in the form of
OR(B5="0439";B5="0535";B5="0536";B5="0567";B5="0811";B5="0898";B5="0923";B5="0936";B5="0941";B5="0957";B5="0972")
The arguments changes frequently and every time, I have to change them manually. I have the statements in a list in the form of
0439
0535
0567
etc
Is there any way that I can "feed" the function automatically from the list.
I have some basic Macro self-taught experience, so if there is a macro invlolved I can try it.
Thank you
Bookmarks