Note: The other languages of the website are Google-translated. Back to English
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
  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