I'm using Excel 2011 on my Mac, and I need to find a way to make excel do the following in a large amount of data:
Put into words, if column 6 doesn't equal the total, then the input needs to be the next cell to the right. Sorry this is the best way I know how to explain it, please let me know how to fix it!
Thanks,
Joel
<tbody>
</tbody>
Put into words, if column 6 doesn't equal the total, then the input needs to be the next cell to the right. Sorry this is the best way I know how to explain it, please let me know how to fix it!
Thanks,
Joel
1 | 2 | 3 | 4 | 5 | 6 | 7 | |
A | Total | First nonblank entry | Formula I need to figure out | ||||
B | 3 | 1 | 4 | 3 | if(B5=B4,0,if not then the cell after B1 which is B2 | ||
C | 3 | 3 | 3 | Should be 0 | |||
D | 3 | 3 | 3 | Should be 0 | |||
E | 5 | 1 | 6 | 5 | Should be 0 | ||
F | 3 | 2 | 3 | 8 | 3 | Should be 2 | |
G | 1 | 1 | 1 | Should be 1 |
<tbody>
</tbody>