Combining rows
Closed
Matt406
-
Jun 1, 2015 at 03:04 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jun 2, 2015 at 11:23 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jun 2, 2015 at 11:23 AM
Related:
- Combining rows
- How to delete rows in word - Guide
- Repeat rows in excel - Guide
- Vba insert multiple rows - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- Excel duplicate rows delete - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
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
