Offset

[Guest]

I have data in sheet1 as folows:
row data calucations
1 a 12
2 b 0
3 c 14

I need to use offset formula to get results in sheet2 for rows withoud 0 in
col C
row data calucations
1 a 12
3 c 14
Thanks
Eva

 

[Guest]

Assuming source data in cols A to C in Sheet1, from row1 down,
where the key col = col C

In Sheet2,

Put in A1:
=IF(OR(Sheet1!C1="",Sheet1!C1=0),"",ROW())

Put in B1:
=IF(ROW()>COUNT($A:$A),"",INDEX(Sheet1!A:A,SMALL($A:$A,ROW())))
Copy B1 to D1. Select A11, fill down to cover the max expected extent of
data in Sheet1, eg down to C100. Hide away col A. Cols B to D will return the
required results, ie only lines without zero values (or blanks) in Sheet1's
col C.