Help with lookup of last non-zero value in a row.
Posted by Jeff Hendricks on January 25, 2001 12:28 PM
I am a little bit confused by the following conversation (which was posted a couple of days ago). Why was the cell B1 used if it lies within the range of values that are being examined (A1:G1)? Does that mean that the formulas should be entered in that cell, or is B1 part of the formula? My question stems from the fact that I tried to use this formula to give B2 the value of the last non-zero value within the range of A1:G1 so I typed in the formula in B2, and it gave me the value in A2, or some apparently random values. If you know what I am doing wrong I would greatly appreciate any help. Thanks a million. : I need to select the last cell in a row of values. This cell must be the last one which is not zero. : Eternal gratefulness assured. : Denis