Formula Help Please

[How_Do_I]

In Column B there can be a maximum of 12 unique numbers.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
D1 is a count of how many numbers in Column B
<o> </o>
In F1 I need a formula that will work regardless of how many of my 12 numbers are in Column B.
<o> </o>
So if I place 40 in B3, I would want F1 to = 23, 32, 40
<o> </o>
Can this be done please?

Excel Workbook
	A	B	C	D	E	F
1	1	23		2		23, 32
2	2	32
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	10
11	11
12	12
Sheet1

 

[How_Do_I]

Hi all, I've had a look a Brian's code and was trying to use that on something I read in a different thread...

Basically, how would I return the values in Column B when Column A = 234 please?

Excel Workbook
	A	B	C	D
1	Employees	Stationary
2	234	Pen		Pen, Pad, Pen, Pen, Paper, Paper, Pin, Pad, Pin, Printer, Printer
3	234	Pad
4	345	Pen	Employees	Total Assets
5	654	Pen	234	Pen, Pad, Pen, Pen, Paper, Paper, Pin, Pad, Pin, Printer, Printer
6	645	Paper
7	567	Paper
8	567	Pin
9	345	Pad
10	234	Pin
11	234	Printer
12	645	Printer
Sheet1

 

[meldoc]

Hi Gus,

First non of the codes are mine, I wish.
To do what you ask, use the code by ZVI, posted by MrKowz, in post #13, like this.

Excel Workbook
	A	B	C	D
1	Employees	Stationary
2	234	Pen		Pen, Pad, Pen, Pen, Paper, Paper, Pin, Pad, Pin, Printer, Printer
3	234	Pad
4	345	Pen	Employees	Total Assets
5	654	Pen	234	Pen, Pad, Pin, Printer
6	645	Paper
7	567	Paper
8	567	Pin
9	345	Pad
10	234	Pin
11	234	Printer
12	645	Printer
Sheet1

Excel 2010

Cell Formulas
Range	Formula
D2	=AConcat(B2:B12,", ")

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[How_Do_I]

Brilliant, thanks Brian.

 

[jasonb75]

Using the other version,

Excel Workbook
	A	B	C	D
1	Employees	Stationary
2	234	Pen
3	234	Pad
4	345	Pen	Employees	Total Assets
5	654	Pen	234	Pen,Pad,Pin,Printer,
6	645	Paper
7	567	Paper
8	567	Pin
9	345	Pad
10	234	Pin
11	234	Printer
12	645	Printer
Sheet

It's worth noting that if you have MOREFUNC installed, then you already have MCONCAT, which is, as far as I can see, identical to aconcat.

That said, I think I'll be using ZVI's concatif from now on, it removes the trailing delimiter which the others leave behind, so looks much neater.