Display a list in one column
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 |
Display a list in one column
Hi,
Its probably clear to others, but I'm cornfussed. You have the subvendor numbers in column A and you want them in column C. Why not type =A2 in C2? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Jai" wrote: 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 |
All times are GMT +1. The time now is 10:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com