hey , Excel Lovers
I Want To Count My Data In This Way, Any Help Plz
* In C2 i have 2 of 1
*in C3 i have 1 of 0
in C4 i have 2 of 1
in C5 i have 4 of 0
and son on
Sheet2.........
I Want To Count My Data In This Way, Any Help Plz
* In C2 i have 2 of 1
*in C3 i have 1 of 0
in C4 i have 2 of 1
in C5 i have 4 of 0
and son on
Sheet2.........
| Excel Workbook | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Data | Results | |||
| 2 | 1 | 2 | |||
| 3 | 1 | -1 | |||
| 4 | 0 | 2 | |||
| 5 | 1 | -4 | |||
| 6 | 1 | 1 | |||
| 7 | 0 | -1 | |||
| 8 | 0 | 1 | |||
| 9 | 0 | -5 | |||
| 10 | 0 | 6 | |||
| 11 | 1 | ||||
| 12 | 0 | ||||
| 13 | 1 | ||||
| 14 | 0 | ||||
| 15 | 0 | ||||
| 16 | 0 | ||||
| 17 | 0 | ||||
| 18 | 0 | ||||
| 19 | 1 | ||||
| 20 | 1 | ||||
| 21 | 1 | ||||
| 22 | 1 | ||||
| 23 | 1 | ||||
| 24 | 1 | ||||
Sheet | |||||
