MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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



Posted by Aladin Akyurek on January 25, 2001 1:43 PM

It shouldn't matter whether you array-enter one of those formulas in B1 or B2. I have no idea why you get wrong values. I'm sending you thru email the workbook that shows the machinery.

Aladin

Posted by Aladin Akyurek on January 27, 2001 9:00 AM

Jeff,

Please, see: 9082.html

Aladin :