Note: The other languages of the website are Google-translated. Back to English
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 05 October 2017
  0 Replies
  1.2K 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.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL