RUA Volunteer2?
asked on
How to Randomly or by Sequential steps select rows from an Excel Spreadsheet
I need to either randomly select between (150-300 rows) or by step Rows 5,10,15,20.25.30,35.....et c through 1500 rows of data. This is to have a sampling of data. I thought if I make a counter column I could create some formula that would let me select either (150-300) records or just count out every few rows 5,10,15,20.25.30,35.....et c through 1500 rows of data. Then copy those records (what I do not need would either be suppressed or disappear) and put them on a new sheet. I am building a small set of tables that will be uploaded to a developer license of Salesforce. Any help is greatly appreciated. Thank you.
RM_Opportunity_Table.xlsx
RM_Opportunity_Table.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER