Hi

I need a formula to list all numbers for a Group in one row.
For e.g. Group Number is 100 and sub group number could be any number from 1
to 9999.
Can I set up a formula to pick up all the sub group numbers from one data
base and list in one row like
Group : 100
Family : 102,105 (as many as for Group number 100)
Where I am inputting Group Number in Column called 'Group'
and Coulmn'Family' should autofeed all Numbers for that Group from another
sheet that is Data List.

Please help.

Thanks
Jai