Hi guys,
I have 64 boxes from cell A2 downwards which say: 'S1' in all of the cells. In the 64 boxes from B2 downwards, I see a mixture of content including S1.
I want to write an IF statement saying if B2 has S1 (like A2), return: No change. If B2 has anything other than S1, return: Change
Can anyone help me to write this statement?
Thank you
Bookmarks