Auto generate lists based on a table

%3CLINGO-SUB%20id%3D%22lingo-sub-1665730%22%20slang%3D%22en-US%22%3EAuto%20generate%20lists%20based%20on%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1665730%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%2C%20from%20which%20I%20need%20to%20Auto%20generate%20%2F%20populate%20a%20list%20based%20on%20multiple%20criteria.%20In%20the%20attached%20sheet%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EProblem%201%20-%20Autogenerate%20the%20unique%20lists%20from%20(Column%20B%20and%20D)%20from%20the%20Main%20table.%20On%20the%20basis%20of%20this%20newly%20created%20list%2C%20I%20am%20looking%20for%20all%20the%20unique%20Staff%20names%20(from%20Column%20C%20if%20possible%20or%20else%20from%20Column%20G2%3AJ2)%20required%20in%20the%20corresponding%20office%20IN%20A%20SINGLE%20CELL%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EProblem%202%20-%20Auto%20generate%20a%20List%20of%20Functions%20(column%20D)%20and%20sub%20functions%20(Column%20E)%20for%20each%20staff%20member%20(Joe%20(M13)%20%2C%20Perry%20(O13)%2C%20Tom%20(Q13)%2C%20and%20Steven%20(S13)%20based%20in%20Dallas%20(A22)%20office.%20Next%20to%20each%20staff%20member%2C%20I%20also%20need%20Time%20(column%20F)%20required%20by%20each%20one%20of%20them%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20to%20you%20for%20your%20time%20and%20help.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1665730%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have a table, from which I need to Auto generate / populate a list based on multiple criteria. In the attached sheet 

 

Problem 1 - Autogenerate the unique lists from (Column B and D) from the Main table. On the basis of this newly created list, I am looking for all the unique Staff names (from Column C if possible or else from Column G2:J2) required in the corresponding office IN A SINGLE CELL


Problem 2 - Auto generate a List of Functions (column D) and sub functions (Column E) for each staff member (Joe (M13) , Perry (O13), Tom (Q13), and Steven (S13) based in Dallas (A22) office. Next to each staff member, I also need Time (column F) required by each one of them

 

Thanks to you for your time and help.

0 Replies