copy col."A" to col."B" with a twist???

S

sezuh

Well-known Member
Joined
Nov 19, 2010
Messages
708
Hi,
I was woundering if you could help me in this problem?
I have a list in column “A” and i would like to copy the same list to column “B” but the numbers should be different than what ever in previous row,and spread evenly with all numbers,i’ve done this list by hand and its not that good but for the purpose of an example.vb or excel formula would be greatly appreciated.the list i have got 20825 rows. Here is the example;all the rowsin col."A" mustbe used in col."B".
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<TABLE class=MsoNormalTable style="BACKGROUND: white; mso-cellspacing: 0cm; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 2.0pt 0cm 2.0pt" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed">
<o:p></o:p>

​
</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed">
A<o:p></o:p>

​
</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed">
B<o:p></o:p>

​
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 1"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 13.5pt">
1<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">INPUT<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">RESULT<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 2"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
2<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">1 2 6 13<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">3 5 10 15<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 3"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
3<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">1 3 12 14<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">6 7 8 10<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 4"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
4<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">1 4 5 8<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">6 11 12 15<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 5"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
5<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">1 7 15 16<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">5 6 9 14<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 6"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
6<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">1 9 10 11<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">5 7 12 13<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 7"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
7<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">2 3 7 9<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">1 4 5 8<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 8"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
8<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">2 4 10 12<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">1 7 15 16<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 9"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
9<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">2 5 11 16<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">4 9 13 15<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 10"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
10<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">2 8 14 15<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">1 9 10 11<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 11"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
11<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">3 4 6 16<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">2 8 14 15<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 12"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
12<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">3 5 10 15<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">8 9 12 16<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 13"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
13<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">3 8 11 13<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">2 4 10 12<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 14"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
14<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">4 7 11 14<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">1 2 6 13<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 15"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
15<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">4 9 13 15<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">2 5 11 16<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 16"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
16<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">5 6 9 14<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">3 8 11 13<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 17"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
17<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">5 7 12 13<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">3 4 6 16<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 18"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
18<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">6 7 8 10<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">1 3 12 14<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 19"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
19<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">6 11 12 15<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">10 13 14 16<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 20"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
20<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">8 9 12 16<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">4 7 11 14<o:p></o:p>
​
</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 21; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt">
21<o:p></o:p>​


</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">10 13 14 16<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ebe9ed; PADDING-RIGHT: 2pt; BORDER-TOP: #ebe9ed; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ebe9ed; PADDING-TOP: 0cm; BORDER-BOTTOM: #ebe9ed; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent">2 3 7 9<o:p></o:p>

</TD></TR></TBODY></TABLE>​
Thanks
sezuh
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
I can see numbers that are used in the previous row in your example. And I don't know what you mean when you say "spread evenly with all numbers".
 
Upvote 0
Hi
thanks for your response, much appreciated.
as far as i know there are no same number in column"B" form previous row.
what i mean by evenly ;ie in rows 2,5,6 number 1 in column "A"is been used with number 5 in column"B" 3 times, it would be better if other numbers used
instead.those numbers are taken from Combin(16,4) .do you think its possible
to solve this problem?
thanks again
sezuh
 
Upvote 0
Hi,

I think you mean there is no same number from the previous column.

As for spreading evenly, I don't think there's an easy way to do want you want. Do you have a list of the Combin(16,4) possible combinations stored anywhere? If so, I think you could randomly pick one that's different ( i.e. all numbers different ) from the previous column ... and do that process in a loop in VBA for each row of your 20825 area ... would that do?
 
Upvote 0
hi Glenn,
yes i mean from previous column, sorry...!
i need to use same combination in column"A" in column "B",spreading as evenly possible it does not have to be 100% ,with no same numbers from previous column to be repeated in same rows.
yes i have the lists for combin(16,4)=1820 and combin(51,3)=20825
stored.if you can help i would greatly appreciate.
thanks
sezuh
 
Upvote 0
I'll send you a Private Message to ask for your email, and I'll send an example.
 
Upvote 0
Hi,
Thanks to wonderful and excellent help of Glenn this tread has been solved.
thanks you very very very much indeed.......
sezuh
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
622
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question Question
VBA code clean up
Replies
9
Views
580
mumps
mumps
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
Adding a custom message.
Replies
1
Views
663
Micron
M

Forum statistics

Threads
1,224,560
Messages
6,179,520
Members
452,922
Latest member
nstaab07

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top