ExcelBanter - How to copy cell values from random series

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

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

- - How to copy cell values from random series (https://www.excelbanter.com/excel-worksheet-functions/265496-how-copy-cell-values-random-series.html)

pkeyl

How to copy cell values from random series

I have random series in A1:A50 with formula =randbetween(45,57) NOW i want to run this random series till in this series i got 46,51 consecutively at any place between A1:A50 also now if this condition is met then i want to copy all the cell values cells having 46,51 respective in Column C, Can any one show me how to achieve this?

All times are GMT +1. The time now is 02:00 PM.