Thread: Weight Tracking
View Single Post
Old 12-25-10, 03:26 AM
  #11  
jethro56 
Watching and waiting.
 
jethro56's Avatar
 
Join Date: Oct 2010
Location: Mattoon,Ill
Posts: 2,023

Bikes: Trek 7300 Trek Madone 4.5 Surly Cross Check

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 11 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by bubonik
Stuck on this portion of code, if anyone can help me figure out why its 0 I would appreciate it.

Code:
=ARRAYFORMULA((index('2011'!B2:B32,Small(if('2011'!B2:B32<>0,row('2011'!B2:B32)),1),1))-(index('2011'!B2:B32,large(if('2011'!B2:B32<>0,row('2011'!B2:B32)),1),1)))
Didn't download spreadsheet so I may be offbase. But if large = small or range is unpopulated the result = 0
jethro56 is offline  
Reply