F Frank Kabel Mar 10, 2004 #2 Hi OFFSET return a cell references shifted (and resized). OFFSET(Cell_base,row_index,col_index,[heigth],[width]) e.g. OFFSET($A$1,1,2) shift the cell reference from $A$1 one row down and 2 columns to the rigth -> $C$3
Hi OFFSET return a cell references shifted (and resized). OFFSET(Cell_base,row_index,col_index,[heigth],[width]) e.g. OFFSET($A$1,1,2) shift the cell reference from $A$1 one row down and 2 columns to the rigth -> $C$3
J JE McGimpsey Mar 10, 2004 #3 You've already had two responses to your previous post on this topic. If you can't find the answers, search the archives: http://google.com/advanced_group_search?q=group:*excel* Put "mangesh" in the author field and you'll find all of the previous posts you've made and any replies. If you didn't understand, or if the replies weren't adequate, post back with an explanation of what you don't understand.
You've already had two responses to your previous post on this topic. If you can't find the answers, search the archives: http://google.com/advanced_group_search?q=group:*excel* Put "mangesh" in the author field and you'll find all of the previous posts you've made and any replies. If you didn't understand, or if the replies weren't adequate, post back with an explanation of what you don't understand.
