Can anyone help me mixed in order the 6 columns , need to put tham like 111112,111113, so on so for up to 38 54 60 56 50 34, i cant do
=$A3&$B3&$C3&$D3&$E3&F3 end drag it down, the ar other way more easy to do it?
Can anyone help me mixed in order the 6 columns , need to put tham like 111112,111113, so on so for up to 38 54 60 56 50 34, i cant do
=$A3&$B3&$C3&$D3&$E3&F3 end drag it down, the ar other way more easy to do it?
I don't quite know what you are after as that seems fine as a solution, but you can try =CONCATENATE(A3,B3,C3,D3,E3,F3)
the ar 292 numbers on 6 columns i what to mix thes way:
=$A$3&$B$3&$C$3&$D$3&$E$3&F4
010101010102
010101010103
010101010104
010101010105
010101010106
i make only last 2 columns ar more easy to to it; if it to long let make it 10 numbers on 6 columns but the idee it same ,how to mix thes 6 columns on easy way?
Are you trying to get all possible combination of numbers from the 6 columns? So if you use 10 numbers from each column you end up with 10^6 combinations (1 million combinations)?
Yes 1 mil. comb. but if it 3 columns at 10 number (it only 1000 comb.), how to mix tham? Is there any formula that can mix these numbers?
A macro would probably give you more control over what you want. However if you want to mix 10 rows of the last three columns try:
=A$3&B$3&C$3&OFFSET(D$3,MOD(INT(ROW()-3)/100,10),0)&OFFSET(E$3,MOD(INT(ROW()-3)/10,10),0)&OFFSET(F$3,MOD(ROW()-3,10),0)
it should create the result in a single column. You may have to play around with the formula if you change the cells in your spreadsheet
=A$3&B$3&C$3&OFFSET(D$3;MOD(INT(ROW()-3)/100;10);0)&OFFSET(E$3;MOD(INT(ROW()-3)/100;10);0)&OFFSET(F$3;MOD(ROW()-3/100;10);0) i change the , in to ; idont know why it thes way on me Excel, any way it no working it gave me 0
the ";" instead of "," is based on your windows settings, you can change it if you want by changing the 'list separator' symbol i the language->date & time settings.
In the formula you have changed for formula in two parts where "/100" is given, the first is /100, the second is /10 and third does not divide at all. See above. You will need to copy to all cells you are using for the output
appreciate someone's help? then click *
Thank you so much for your help, it working i no make attention on the /100 , but now i nkow what i cant change if i whan more than 10 number's on column , how i put solved???
Below is the solution if you want to expand the number of rows to 15. You can change all instances of 15 to however many number of rows you need
=A$3&B$3&C$3&OFFSET(D$3,MOD(INT(ROW()-3)/15^2,15),0)&OFFSET(E$3,MOD(INT(ROW()-3)/15,15),0)&OFFSET(F$3,MOD((ROW()-3),15),0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks