find last cell in a column but not a formula
I have a worksheet with a list of equipment and uptime rates. each week I
add a new row with the current weeks rate information. I use this data in a
powerpoint slide. So i used the formula in a different cell to pull just the
current weeks info. then I use that to link to the power point slides so it
auto updates. When I use the formula on a percentage it results in '1'
instead of percentage. thanks for everything in advance
I'm using the following formula to get the last cell:
=IF(COUNTA(A3:A97)=0,"None!",LOOKUP(2,1/(LEN(A3:A97)0),A3:A97))
the formulas in the cell is a simple percentage formula:
=(B13-C13-D13-E13)/B13
|