COMPLEX FORMULA PLEASE ? :s

excel test.PNG

Hi,

I would like to automate something but no clue how

I need to compare cells to other cells and if there is a mismatch, then the mismatching value has to be pasted.
concretely, if Tip Bet is not in B2, it need to be pasted in C2. AND if EGB is not in B2, it needs to be pasted in C2 as well. Same thing for all B cells with all D cells.

Is it even possible?

Thanks

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.

To attach a file to your post,

• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post