Every 75 rows
 

I need a formula that will enter a value equal to a cell. In the next
row I need the value to equal the cell 75 rows from the original cell.
Example F1=B30, F2=B105, F3=B180 and so on.
TIA
John

Every 75 rows
 

Hi John,

=INDEX($B$30:$B$214,ROW()*75-74)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ups.com...
|I need a formula that will enter a value equal to a cell. In the next
| row I need the value to equal the cell 75 rows from the original cell.
| Example F1=B30, F2=B105, F3=B180 and so on.
| TIA
| John
|