Thread: Multiple names
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
freezerpang freezerpang is offline
external usenet poster
 
Posts: 3
Default Multiple names

I have a excel sheet full of my customers names and my staff names. would
like to sort out under each customer's company, shows who are the staffs are
attached to the customer in a main worksheet. Tried using LOOKUP but it only
show 1 staff name but i have more than 1 staff attached to my customer. tried
alot of methods but just can't do it. pls help.