Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


Please help: Large volume, random data alteration that I don't know how to solve

  • Bob Glick
  • Topic Author
  • Offline
  • New Member
  • Nouveau membre
1 year 6 months ago #102 by Bob Glick
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.

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo