Is there a function that will return/copy an entire row?

  • Thread starter Thread starter snord
  • Start date Start date
S

snord

I have a worksheet containing a few thousand rows and I used randbetween to
select 50 of them. Now I need to make a list containing just those 50
records. So far I am just manually marking an "X" in the first column of
each of the identified rows, so I can filter to that and copy them to a new
list. I am not very experienced in formulas, but there must be a better way
to do this! Any ideas?
 
I have a worksheet containing a few thousand rows and I used
randbetween to select 50 of them. Now I need to make a list
containing just those 50 records. So far I am just manually marking
an "X" in the first column of each of the identified rows, so I can
filter to that and copy them to a new list. I am not very experienced
in formulas, but there must be a better way to do this! Any ideas?
Click to expand...

Do you mean you need fifty random values returned from your range? How
about:

=INDIRECT("A" & RANDBETWEEN(1,5000))

The above returns a random value from the values in the range A1 to A5000.
Copy it to fifty rows.
 
Back
Top