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

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 |

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of May 21, 2014.