Excel: Formula That Selects Next Cell


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.


For more resources for Microsoft Excel