Outlet Supervisor Host Bar Floor Runner
Level 1 2 1 1 4 1
Mezzanine 1 1 1 5 1
Level 2 2 1 2 8 3
Indicative list
Supervisor
Supervisor
Host
Bar
Bar
Floor
Floor
Floor
Floor
Runner
Supervisor
Host
Bar
Floor
Floor
Floor
…
Outlet Supervisor Host Bar Floor Runner
Level 1 2 1 1 4 1
Mezzanine 1 1 1 5 1
Level 2 2 1 2 8 3
Indicative list
Supervisor
Supervisor
Host
Bar
Bar
Floor
Floor
Floor
Floor
Runner
Supervisor
Host
Bar
Floor
Floor
Floor
…
Welcome to the forum.
What's the logic?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sorry the post wasn't clear. The table should be as follows:
Attachment 651464
With the result being
Indicative list
Supervisor
Supervisor
Host
Bar
Floor
Floor
Floor
Supervisor
Host
Bar
Floor
Floor
Floor
Floor
…
Still can’t fathom it - sorry.
Try explaining in words what you are trying to achieve.
I'm trying to work out the formula to build a column of roles from the numbers required as per the table, so that the column builds down from the numbers required in each row and then builds the next row and so on, so for example if i need 1 supervisor and 2 bar in one venue then 2 supervisor and 3 bar in another it will build them like below:
Supervisor
Bar
Bar
Supervisor
Supervisor
Bar
Bar
Bar
Does that make sense?
Last edited by Nicnoo; 11-25-2019 at 10:57 PM.
Please try
J4
Regards.Please Login or Register to view this content.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
Hi there,
No that didn't work, but I am not sure what the content is meant to be in L3 or is that just a blank cell?
Sorry for my mistake >_<
Plese try again.
Regards.Please Login or Register to view this content.
Please try at J4
Formula:Please Login or Register to view this content.
Or Power Query
Open Power Query/Get and Transform. Click on New Query.
Open blank query in the editor, launch Advanced Editor and paste in the following code.
Please Login or Register to view this content.
THANK YOU! That is brilliant. Worked perfectly.
Can you then reverse it to build the other list, such as.
Level 1
Level 1
Level 1
Level 1
Level 1
Level 1
Level 1
Level 1
Level 1
Mezzanine
Mezzanine
Mezzanine
Mezzanine
…
Or can I get away with a shorter formula for that?
Please try at
N4
Formula:Please Login or Register to view this content.
O4
Formula:Please Login or Register to view this content.
Last edited by Bo_Ry; 11-29-2019 at 03:10 AM.
Hi there,
Works perfectly. Thank you so much for all your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks