Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose random series of cells [email protected] Excel Worksheet Functions 1 November 16th 08 06:36 PM
Transpose random series of cells [email protected] Excel Worksheet Functions 0 November 15th 08 09:00 PM
Calling cell values from random sheets from a base sheet [email protected] Excel Worksheet Functions 2 January 19th 07 09:21 PM
Random Values totaling Cell value inkpassion Excel Discussion (Misc queries) 5 September 7th 05 08:09 AM
how to save/copy data in cell to a series of cells on another pg Azrael Excel Worksheet Functions 0 August 29th 05 06:31 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"