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?