- Registration date
- Sunday September 12, 2010
- Last seen
- January 18, 2021
Well, you could use a combination of IF and OR functions to check if the result needs to be a 1 or 0. Like:
So if either B1 or B2 is 1 then result will be 1, otherwise 0.
But depending on your amount of data it will be more beneficial to use a code.
So how much data are we talking about?
And also, is your data always grouped on 2 lines?
Do feel free to ask anything you like. I'm always happy to assist anyone wanting to learn more about Excel.