Menu
There are 5 columns (first name, email, userid, app name) and I want to randomly select 10% of these rows and export it eventually to a CSV while maintaining the column headers i listed above. thanks a million
716
(1) In a blank cell enter the formula =RANDBETWEEN(1,15), and drag the fill handle to the range you need. (2) In the cell where you will fill name randomly from the given list, enter the formula =VLOOKUP(C2,$A$1:$B$16,2,FALSE), and drag the fill handle to the range you need.
Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria,—such as the last cell on the worksheet that contains data or formatting.
I don't know how random you want this to be but adding a column containing =RANDBETWEEN(1,85038) copied down to suit, then sorting that column and selecting the first 8,504 rows should give quite an 'arbitrary' result.
107
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
