hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,213
- Office Version
- 2010
- Platform
- Windows
- Mobile
Column B2:B7 is EITHER of 1 OR 0
Input Data Range D2:H7 is EITHER of TRUE OR FALSE
Input ‘Header’ (above D2:H7) i.e. D1:H1 is 111, 222, 333, 444 & 555
Output Range J2:N7 as shown:
How to accomplish.
Thanks in advance
I am using Excel 2007
Sheet2
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 41px"><col style="WIDTH: 13px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 13px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"></colgroup><tbody>
</tbody>
Input Data Range D2:H7 is EITHER of TRUE OR FALSE
Input ‘Header’ (above D2:H7) i.e. D1:H1 is 111, 222, 333, 444 & 555
Output Range J2:N7 as shown:
How to accomplish.
Thanks in advance
I am using Excel 2007
Sheet2
B | C | D | E | F | G | H | I | J | K | L | M | N | |
1 | 1 or 0 | 111 | 222 | 333 | 444 | 555 | |||||||
2 | 1 | TRUE | TRUE | TRUE | TRUE | TRUE | 111 | 222 | 333 | 444 | 555 | ||
3 | 1 | FALSE | FALSE | FALSE | FALSE | FALSE | 0 | 0 | 0 | 0 | 0 | ||
4 | 0 | TRUE | TRUE | TRUE | TRUE | TRUE | 0 | 0 | 0 | 0 | 0 | ||
5 | 0 | FALSE | FALSE | FALSE | FALSE | FALSE | 0 | 0 | 0 | 0 | 0 | ||
6 | 1 | TRUE | FALSE | TRUE | FALSE | TRUE | 111 | 0 | 333 | 0 | 555 | ||
7 | 1 | TRUE | TRUE | TRUE | FALSE | FALSE | 111 | 222 | 333 | 0 | 0 |
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 41px"><col style="WIDTH: 13px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 13px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"><col style="WIDTH: 42px"></colgroup><tbody>
</tbody>