ExcelBanter - Want to extract from a list of 4700 rows each 185th row to a new w

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Want to extract from a list of 4700 rows each 185th row to a new w (https://www.excelbanter.com/excel-worksheet-functions/37202-want-extract-list-4700-rows-each-185th-row-new-w.html)

waltphipps

Want to extract from a list of 4700 rows each 185th row to a new w

olasa

Use something like:
=OFFSET(A1,(ROW()-1)*185,0)

HTH
Ola Sandström

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390357

All times are GMT +1. The time now is 10:32 PM.