View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default get value from cell value 4 rows above in the same column

There may be a better way but this works:

Enter this is A24 and copy down as needed:

=IF(SUMPRODUCT(--(MOD(ROW(),4))),"",SUMPRODUCT(--(MOD(ROW(A$24:A24),4)=0)))

Biff

"Corey" wrote in message
...
i have a index value in each cell ranging from cell A24 - A280. Every 4th
row.
A24,A32,A36.........A280.

What i want to be able to do is if i delete some rows(always 4 rows at a
time) the next cell value will always be 1 greater than the cell value
above it.

How can i do this by formula or code.
eg.
A24 = 1
A32 = 2
A36 = 3
A40 = 4
A44 = 5
A48 = 6

If say i need to delete the rows that contain the A40 cell(A40 -
A43){4rows},
then the value in A44 WAS 5, but now it needs to be a value of 4(1 more
than the value above it).

How can i do this?

Corey....