Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 05 October 2017
  0 Replies
  2.3K Visits
0
Votes
Undo
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.
There are no replies made for this post yet.