Add letters to numbers in column "B"?

Maybe this:

=B11&CHOOSE(MOD(ROW(),6)+1,"A","B","C","D","E","F")

Depending on the starting row (and if you want the first cell in B col to have the "A" attached) you can change the order of the letters within the CHOOSE() to suit. As is, the "A" will attach to rows 6, 12, 18 etc

Hi cutter,
thanks for your response,
the formula almost there,but it needs some adjustment.
instead of "B11" ;"B1" and also say first cell is "A" then A should not be used with "1;2;3;4;5" again every letter to be used with any numbers in column"A" once.
i hope i cleared for you.
thanks again
Kind regards

hi,
i tried the formula unfortunately it does not give right result,if letter"A" start with first row
1 2 3 4 5,next should be with 6......,11....,16....21...as isaid before every letter should be used with every number once only.maybe it needs VB code??
any help would be appreciated.

Sorry, I totally misunderstood what you were looking for. I don't know, offhand, how to accomplish what you want.

Cutter,
thanks for your effort, atleast you gave something....much appreciated.
so is there any one have some suggestion please???
Regards

Osvaldo, thanks for your help.
this formula also giving same result as Cutter's.
if you notice there are 1-25 numbers been used in the list what it need is for each letter to be used with every number once only.example of your formula result ;
1 2 3 4 5A; 2 6 15 19 23 A; 3 7 11 20 24 A ; 4 8 12 16 25 A; 5 9 13 17 21 A
number 2 and 5 used twice .if they have been used once then it is correct result.
anyhow thanks for your effort.
ragards

Hi Cutter,
Thats right first number is never more than 25.and also the first number in the string of 5 numbers and what other numbers in cell that determines what letter and number is used.lets look to next row which is; 1 6 11 16 21 B ; so next row should start with num.2 but not contain numbers “6 11 16 or 21” ; 2 7 12 17 22 B ;next row should start with num 3 ,but not contain numbers from the first 2 rows and continue with rest of the all letters.
I hope this help to clarify to solve the problem.
regards

So, in actual fact you aren't only asking for a method to attach the appropriate letter but for a method to arrange the numbers as well. Is that correct?

Hi,
I’m only asking for method to attach the appropriate letters to the list in column “A” with the criteria
I explained in my previous post,you arrange the letters so each letter used 5 times(rows) and in those 5 rows must contain all 1 to 25 numbers in it.
Thanks for your time and help..
regards

OK, one last stab at trying to understand this one.

With your sample list (shown in original post) occupying col A starting in row 1

Use this helper column in B (or whatever - I used B)
In B1 and dragged down:
=LEFT(A1,2)*1

In C1 this:
=A1&" A"

In C2 and dragged down:
=A2&" "&CHOOSE(COUNTIF(B$1:B2,B2),"A","B","C","D","E","F")

Hi,
thanks for the formula but unfotunately still not giving the result.
every letter suppose to be used 5 times and each letter to be attached to rows contain
numbers from "1 to 25" here is your formulas result;
1 2 3 4 5 A
1 6 11 16 21 B
1 7 13 19 25 C
1 8 15 17 24 D
1 9 12 20 23 E
1 10 14 18 22 F
2 6 15 19 23 A
2 7 12 17 22 B
2 8 14 20 21 C
2 9 11 18 25 D
2 10 13 16 24 E
3 6 14 17 25 A
3 7 11 20 24 B
3 8 13 18 23 C
3 9 15 16 22 D
3 10 12 19 21 E
4 6 13 20 22 A
4 7 15 18 21 B
4 8 12 16 25 C
4 9 14 19 24 D
4 10 11 17 23 E
5 6 12 18 24 A
5 7 14 16 23 B
5 8 11 19 22 C
5 9 13 17 21 D
5 10 15 20 25 E
6 7 8 9 10 A
11 12 13 14 15 A
16 17 18 19 20 A
21 22 23 24 25 A

i think it need VB code?
regards

I think it needs you to supply a sample file with what you want - clearly showing the results you expect and why.

As they say on Dragon's Den - I'm Out.

Hi Cutter,
you did what you can,
Thanks for your time and effort.....much appreciated,
regards

Bump......

Hi Marcol,
thanks for your time and effort,
the code works great you're A Genius..... thanks a mill. would it be possible to use it in different list and with out helper column.
if i may ask how did you post the attachment file?
i could not open the macro will not allow me unless i enable the macro,i used new
workbook to try your code.
thanks and God Bless...
sem

hi Marcol,
thanks for the help ....much appreciated.
i think i'm going to keep helper columns but instead of vertically could i have them horizontaly,and suppose i used different list with more letters which part of the code do i need to change inorder to get the right result. say 19 letters and they are going to be used 13 times each but with the same principal, would the code work ???
i attached the exl book i hope its ok.
also instead of letters would it be possible to have numbers,and what change have to be done to accomodate the numbers??
regards

Hi Alistair,
As ever thanks for for your time and great help,much appreciated.
This work not for analysing its like Jigsaw Puzzle but with numbers and instead of looking for jigsaw
piece ,we look for rows in the list to solve the problem by completing the row or columns to specific
numbers like the list we solved ,it’s got “1 to 25” for each letter,”A to F”.i hope i explained myself..!
in the code it’s only up to letter”F” input ,do i need to increase if more letter needed like;
Dim NoFoundE As Boolean, NoFoundF As Boolean
>>>>>>>>>>>TO
Dim NoFoundG As Boolean, NoFoundH As Boolean
>>>>>>>>>>
NoFoundF = IsNumberInRange(Columns("H:H"), arrTemp)
>>>>>>>>>>>TO
NoFoundG = IsNumberInRange(Columns("I:I"), arrTemp)
>>>>>>>>>>>>
Case NoFoundF
AppendToFoundList 8, arrTemp
Range("B" & RowNo) = "F"
>>>>>>>>>>>>>>TO
Case NoFoundG
AppendToFoundList 8, arrTemp
Range("B" & RowNo) = "G"


How many row start with number “1” dictate how many letters we are going to use,in Sheet 1 on the attachment is the right result;in sheet 2 different list but same amount of rows but i did not get the right result ???in Sheet3 for each letter should start with “1” using all rows with number”1” but somehow they are not am i doing something wrong???in Sheet 5 should not be a column”T” i put thick lines to see more clear if all rows been used all columns missing one or more rows but maybe this it can not be solved?
Thanks again for your effort,
Kind Regards
Sem

thanks Alistair and i'm sorry for all this trouble,
i wish i have box lid with all the answers,otherwise i would not bother anyone.
Have you heard about "Social Golfer Problem" those questions i am asking are all similar to that problem.
Thanks and God Bless.
Sem

Hi Alistair,
Thank you very very very much for the new VBcode its better than the first two code,i really appreciate your help.Sheet1 and 3 is perfect ,sheet2,4 and 5 also good but not solved ,in sheet 6,7and8 i get error “type mismatch,Run time error 13 “ and it highlite this line:
“Do While Left(Cells(RowNo + 1, 1), InStr(1, Cells(RowNo + 1, 1), " ")) * 1 = 1”
If you could fix Sheet 6,7 and8 i’ll be very happy man,because my curiosity is killing me not the cat!!!!!not knowing if those problems can be solved or not.for years i been trying by pen and paper
Recently i started to use computer to see if i can solve those problems.
for your challange is it possible to implement this VB code to full Combin(15,5)and
Combin(25,5),you don’t have to do it,but is it possible????????
I can not thank you enough for your invaluable time and help...much appreciated.
Kind regards and God Bless
Sem

Hi Alistair,
If i thank you from here to The Moon will not be enough ....then again i’m over the Moon.....!!!!!!!
I tried it on over than 50 list it still gives “mismatch error or “”Invalid procedure call or argument error 5”” when i try it on lists over than 1300 combinations ???? even i tryed it on Combin(15,5)and Combin(25,5) it gives same error any idea why???.but this result in this attachement is out of this world ,this how all the lists results should be.thats why i would like to share it with you ,because this isthe result of your Outstanding work....greatly appreciated.
When i said its not solved in my previous post ,it did not give the same result as the the list in attachment
Have a wonderful day.....
Regards
sem

Alistair ,I’m sorry if i gave indication to seek an answer which i meant not to,but i can assure
You i have no interest in “Social Golfer problem” at all,the only thing i’m seeking answer to
Are attachment in post 28, 30 and Combin(15,5);(25,5) which your last Vb code have solved some of them ,and i greatly appreciate for all time and help.the only reason i posted the last attachment is to show you the result of your excellent work and nothing else.
Thanks again and kind regards
Sem