Thread: Offset
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
Default Offset

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