Forum Discussion

bryen79's avatar
bryen79
Copper Contributor
Oct 19, 2022
Solved

How to copy a certain number of cells based on a value?

Hello!

 

I have 6 columns of timestamps, with numerous rows, if I want to only copy (by random selection) the number of cells in each row, by a given number (in column 7), pasting the data starting in column 8, what IF formula could I use?

Here is a photo of what I mean.  https://ibb.co/YD1httX

 

 

 

     Count    

 

8:45 AM

9:51 AM

10:58 AM

3:27 PM

5:25 PM

8:23 PM

2

8:45 AM

9:51 AM

  

 

1:42 AM

12:30 PM

8:19 PM

8:30 PM

8:48 PM

8:59 PM

1

8:48 PM

   

 

3:57 AM

5:26 AM

6:08 AM

8:31 PM

10:12 PM

11:13 PM

5

5:26 AM

6:08 AM

8:31 PM

10:12 PM

11:13 PM

1:31 AM

4:34 AM

6:15 PM

7:05 PM

8:05 PM

8:28 PM

3

6:15 PM

7:05 PM

8:05 PM

 

 

2:33 AM

2:49 AM

9:43 AM

11:20 AM

3:52 PM

9:56 PM

4

2:49 AM

9:43 AM

11:20 AM

3:52 PM

 

 

Formulas and Functions

3 Replies

  • bryen79's avatar
    bryen79
    Copper Contributor
    Oct 19, 2022
    Thanks to both of you for your responses!! I am so grateful! You've saved me a ton of time!!! Both answers are great! I marked the one that is the easiest for me to use but wanted to point out that both are great! Thanks again!!!!
    • mtarler's avatar
      mtarler
      Silver Contributor
      Oct 19, 2022

      bryen79  Alternate without helper cells

      =LET(in,A8:F8,
n,G8,
count_in,COLUMNS(in),
rand_in,SORTBY(in,RANDARRAY(1,count_in)),
TRANSPOSE(SORT(INDEX(rand_in,SEQUENCE(n)))))

      The above formula is based on data on row 8

Resources