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...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Oct 19, 2022

    bryen79 

    See the attached demo workbook. It uses dynamic array formulas, available in Microsoft 365 and Office 2021.

HansVogelaar's avatar
HansVogelaar
MVP
Oct 19, 2022

bryen79 

See the attached demo workbook. It uses dynamic array formulas, available in Microsoft 365 and Office 2021.

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