Combining rows
Closed
Matt406
-
Jun 1, 2015 at 03:04 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 2, 2015 at 11:23 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 2, 2015 at 11:23 AM
Related:
- Combining rows
- How to delete rows and columns in word - Guide
- Excel insert multiple rows - Guide
- Repeat rows in excel - Guide
- Delete all rows except first and last row ✓ - Excel Forum
- Compare dates within rows - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 2, 2015 at 11:23 AM
Jun 2, 2015 at 11:23 AM
Hi Matt,
Well, you could use a combination of IF and OR functions to check if the result needs to be a 1 or 0. Like:
=IF(OR(B1=1,B2=1),1,0)
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.
Best regards,
Trowa
Well, you could use a combination of IF and OR functions to check if the result needs to be a 1 or 0. Like:
=IF(OR(B1=1,B2=1),1,0)
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.
Best regards,
Trowa
