projectatpel
New Member
- Joined
- Oct 18, 2013
- Messages
- 11
Formula using LOOKUP function is not working for values generated from calculations in a column. I need to find the last non zero value. I have used the formula =LOOKUP(9.99E+307,1/(C9:C208<>0),C9:C208) the column C has values that are calculated based on other cells in the sheet. Attached at the following links is my excel file.Every thing is described in the file Urgent..... http://www.filedropper.com/myrequirement Wikisend: free file sharing service |
<tbody>
</tbody>