Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
John Calder John Calder is offline
external usenet poster
 
Posts: 176
Default Formula Help

Hi

I run Excel 2K.

I have one column and 500 rows of data on one sheet. On another sheet I
want to have a formula that is in every 3rd row which reads each of the
entries in the first sheet.

I can do this manually of course, however when I try to copy it down the
sheet the cell references are all wrong because I am jumping 3 rows at a
time. Is there a formula that will allow me just to copy it down in 3 cell
increments but have it refer to the sequential cells in the 1st sheet.


Thanks