Log in

View Full Version : cheap microsoft office 2010 generator key Repeatin


englishg9o
03-13-2011, 01:30 PM
imagined this could well be helpful to share to determine how other Excel individuals might have solved this concern. I got a question recently from a customer asking how to automatically take a set of values in one column,office 2010 serial sale (http://www.windows7professionalkey.com/office-2010-key), say: repeat each value, say, 4 times in the next column,office pro plus 2010 32 bit key (http://www.windows7professionalkey.com/office-2010-key), so that it looks something like this: and so on. response: the only way to truly do this automatically is to write a custom macro. However, if you can suffer through a few extra clicks,discount microsoft office 2007 activation (http://www.windows7professionalkey.com/office-2007-key), then my suggestion may be to (using the example data above): Select the three input cells (e.g. A1:A3)
Select “Copy” (Ctrl+C)
Select the next 9 cells underneath these inputs (A4:A12)
Select “Paste” (Ctrl+V)
Click the Sort button to sort the data into 3 distinct buckets (600, 1000,cheap microsoft office 2010 generator key (http://www.windows7professionalkey.com/office-2010-key), 5000).
step #3,office 2007 Professional Plus generator (http://www.windows7professionalkey.com/office-2007-key), the number of cells you select will always be: NumberOfInputs x NumberOfRepetitions – NumberofInputs. In this case: 3 x 4 – 3 = 9. seemed to work well enough for the customer. What do you think? Is there another (better?) way?