Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell Dropdown List. Display alternate text than found in list. | Excel Discussion (Misc queries) | |||
Dropdown list doesn't display from the top of the list | Excel Discussion (Misc queries) | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Display list from one colum if value in other column matches x | Excel Discussion (Misc queries) | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions |