Hi!

I can get the data extracted into individual cells but
cannot get an array of values in a single cell:

Assume the raw data is on Sheet1 A2:B7.

On the summary sheet, the reuse codes are listed in column
A1:Ax

In C1 enter this array formula with the key combo of
CTRL,SHIFT,ENTER. Copy down then across:

=INDEX(Sheet1!$A$2:$A$7,SMALL(IF(Sheet1!$B$2:$B$7= $A1,ROW
($A$1:$A$6)),COLUMN(A:A)))

When data is exhausted that meets the certain criteria a
#NUM! error will be returned. You can suppress the errors
by using this formula:

=IF(ISERROR(INDEX(Sheet1!$A$2:$A$7,SMALL(IF(Sheet1 !
$B$2:$B$7=$A1,ROW($A$1:$A$6)),COLUMN(A:A)))),"",IN DEX
(Sheet1!$A$2:$A$7,SMALL(IF(Sheet1!$B$2:$B$7=$A1,RO W
($A$1:$A$6)),COLUMN(A:A)))

Or, you could use a conditional format to hide the #NUM!
return.

Biff

-----Original Message-----

OK, this one has me stumped. Anyone with creative
ideas? ;)

I have one worksheet with values such as this:


Code:
--------------------
Node ReuseCode
2 C-C01
3 C-C03
4 C-C01
5 C-C03
6 C-C02
7 C-C01
--------------------


On another worksheet, I have the following:


Code:
--------------------
ReuseCode Name
Initiating Nodes
C-C01 Policy A
C-C02 Policy B
C-C03 General Information
--------------------


I'd like the Initiating Nodes column to be filled with an
array of
values from the first worksheet. The result would look
like this:


Code:
--------------------
ReuseCode Name
Initiating Nodes
C-C01 Policy A 2, 4, 7
C-C02 Policy B 6
C-C03 General Information 3, 5
--------------------


I've fiddled with formulas, but I am positively stumped.
Three cheers
for any bright ideas!

Thanks :)
Drew


--
AthleteTO
----------------------------------------------------------
--------------
AthleteTO's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=15943
View this thread:
http://www.excelforum.com/showthread...hreadid=274218

.