Hi,

I have a list of vendors by numbers where some vendors numbers are
sub-vendors, grouped with their main vendor number. I need a formula so I can
display a list of vendors grouped with that main vendor. For example :

Col. A Col.B Col.C Col.D
Sub-Vendor No. Main Vendor Revenue
19 22 1234
20 22 456
21 22 789
Total 22 19,20,21 2,479

I need formula for Col. C so I can display all the sub-group numbers in one
column.

Please help.

Thanks
Jai