Thread: Offset formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
richy
 
Posts: n/a
Default Offset formula

Thanks for your help Ron.

I have input the formulas and i'm getting #REF!, any idea why ?

Also from your reply I don't understand the A2: 4 entry ? and your
suggestion to put a 7 in A5 on sheet 2.

I appreciate your help with this.

Cheers my friend.

Richard