The formula in column CJ3, is suppose to count the number of times, the values in CI follow the values in row 2, using the values in column CH. The value in CJ 3 & CJ 4 should both be 1. The formula works in another workbook, using single values.
Excel 2007Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
example where the formula works.
Excel 2007Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
| Excel Workbook | ||||||
|---|---|---|---|---|---|---|
| CH | CI | CJ | CK | |||
| 2 | P1 | 012 | 345 | |||
| 3 | 012 | 012 | 0 | 0 | ||
| 4 | 345 | 345 | 0 | 0 | ||
DIGITS SKIP HISTORY | ||||||
#VALUE!
example where the formula works.
| Excel Workbook | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 2 | 02/13/10 | 0 | 9 | 4 | P1 | 0 | ||
| 3 | 02/12/10 | 0 | 3 | 6 | 0 | 1 | ||
Sheet1 | ||||||||
#VALUE!
