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
|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.