Home

random selection of rows

%3CLINGO-SUB%20id%3D%22lingo-sub-583597%22%20slang%3D%22en-US%22%3Erandom%20selection%20of%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583597%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20afternoon.%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20474%20random%20row%20numbers%20to%20select%20from%20a%20dataset%20of%2024241%20data.%3C%2FP%3E%3CP%3EIs%20there%20an%20easy%20way%20to%20select%20these%20specific%20rows%20and%20copy%20them%20onto%20a%20new%20worksheet%3F%3C%2FP%3E%3CP%3EThe%20only%20way%20I%20know%20is%20to%20go%20to%20the%20specific%20row%20using%20CTRL%20and%20arrows%2C%20but%20it%20is%20taking%20me%20long%20to%20do%20it%20this%20way.%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaria%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-583597%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-584358%22%20slang%3D%22en-US%22%3ERe%3A%20random%20selection%20of%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-584358%22%20slang%3D%22en-US%22%3EYou%20may%20use%20those%20specific%20row%20numbers%20as%20your%20lookup_value%20argument%20in%20VLOOKUP%20or%20INDEX-MATCH.%3C%2FLINGO-BODY%3E
Maria_Lopez_UATFCAT
Occasional Visitor

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.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies