View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
James Fullmer
 
Posts: n/a
Default first number in a column not equal to zero

I am have a table that has a row for each day of the month. As I enter the
inventory values for the day the last field in the row is the total for the
day. What formula will give me the most last field in the totals column not
equal to zero?for instance

427T Total
15,358
15,358
4,500 19,520
0
0
0

the formula would return 19520