Master Work
asked on
I need to select only 500 rows covering any range of data (sampling)
Dear All,
I need to select only 500 rows covering any range of the input sheet (sampling) as attached here. The rows should be selected equally to cover the data range.
I need the first row and the last row and the rows between should be equally selected and moved the output sheet.
Regards,
Dallag
Convert-Large-files-to-500-GA.xlsx
I need to select only 500 rows covering any range of the input sheet (sampling) as attached here. The rows should be selected equally to cover the data range.
I need the first row and the last row and the rows between should be equally selected and moved the output sheet.
Regards,
Dallag
Convert-Large-files-to-500-GA.xlsx
ASKER
I need to select 500 rows to cover the range. For example if I have 1000 rows then I should read the first row and skip the second and read the third and skip the fourth. So at the end I will be able to get 500 rows starting from the first row to the last row.
Regards,
Dallag
Regards,
Dallag
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What do you want to happen if you have 1353 rows, such as in your data?
ASKER
Thanks
Just press F5 in your Input sheet and type A1:B500 to select first 500 rows and copy-paste it into Output sheet.