0
Undo
Votes
An existing excel worksheet contains a random array matrix of 137 thousand rows by 17 columns is described below.
1) Column A content is unique for each row.
2) Columns B thru Q have randomly created positive integers ranging from 1 to 743.
I need a "batch process" and approach to accomplish the following 3 tasks:
1) For each of the 137 thousand rows (excluding column A), randomly replace from 0 to 7 data values in columns
B through Q with a blank.
2) Then, for each row, sort columns B through Q from the lowest value to greatest value (blanks cells should appear
to the right of cells with numbers.
l 3) Randomly right-side append to each non-blank cell, an 'A' or 'B'.
For example: a cell containing the value 25 will be changed to 25A or 25B.
1) Column A content is unique for each row.
2) Columns B thru Q have randomly created positive integers ranging from 1 to 743.
I need a "batch process" and approach to accomplish the following 3 tasks:
1) For each of the 137 thousand rows (excluding column A), randomly replace from 0 to 7 data values in columns
B through Q with a blank.
2) Then, for each row, sort columns B through Q from the lowest value to greatest value (blanks cells should appear
to the right of cells with numbers.
l 3) Randomly right-side append to each non-blank cell, an 'A' or 'B'.
For example: a cell containing the value 25 will be changed to 25A or 25B.
There are no replies made for this post yet.