random selection of rows

Copper Contributor

Hello, 

Good afternoon.

I have a list of 474 random row numbers to select from a dataset of 24241 data.

Is there an easy way to select these specific rows and copy them onto a new worksheet?

The only way I know is to go to the specific row using CTRL and arrows, but it is taking me long to do it this way.

Thank you very much.

 

Maria

1 Reply
You may use those specific row numbers as your lookup_value argument in VLOOKUP or INDEX-MATCH.