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
|
|