Forum Discussion
Dividing cells into two lists and keeping lists constant
Hello. I’m using Excel 2016 for PC, and I’m trying to create a guide to putting up posters at the cinema I’m working at. I have a long list of coming premieres and have filtered it to only show ...
your go to solution would be power query with release date as the parameter. Please share your workbook so we can find out where it needs fine tuning and create queries for each list.
cheers
Hi! Thanks for the response.
I have already used power query to filter out any movie we don’t have a poster for and sorted them in the correct order.
The only thing left to do is to divide them into the separate lists. I don’t know how to do it since if I reference a cell in the list, once a release date is passed, all the cells will change.
I’m afraid I can’t attach the file since it’s for internal use only and therefore confidential.
But basically, I reference a large .xls file that shows every movie for every cinema. I filter out any passed premiere, and any premiere more than six months in the future. It shows that in a sheet where I’ve added another column where us who work here can add a check to any poster we have, and then using another power query I filter out any row without that check.
Now in a second sheet I have a list of 25 films in order of release date, automatically set up to remove any movie that passes their release date.
Hopefully that’s enough information to guide me in the correct direction.
If not, thanks for your time.
I have already used power query to filter out any movie we don’t have a poster for and sorted them in the correct order.
The only thing left to do is to divide them into the separate lists. I don’t know how to do it since if I reference a cell in the list, once a release date is passed, all the cells will change.
I’m afraid I can’t attach the file since it’s for internal use only and therefore confidential.
But basically, I reference a large .xls file that shows every movie for every cinema. I filter out any passed premiere, and any premiere more than six months in the future. It shows that in a sheet where I’ve added another column where us who work here can add a check to any poster we have, and then using another power query I filter out any row without that check.
Now in a second sheet I have a list of 25 films in order of release date, automatically set up to remove any movie that passes their release date.
Hopefully that’s enough information to guide me in the correct direction.
If not, thanks for your time.
I dont need the movie titles. you can anonymize the structure of the spreadsheet to show it you can use movie1 movie2 movie3..etc
for the locations u can use location1 location2 etc
In excel the structure of geography of the data dictates what function one can use.
without that intel your guess is as good as mine
you know the structure
and i'm familiar with the excel functions.
so what will it be, your choice.
cheers
- think of it this way
If i give you a grid street map without street names, and I tell you the address of the building to get to, how will you get there- Hi.
The problem is that I’m not as well educated in Excel as I really need to be.
The reference sheet is around 7000 cells, and I don’t have the know how to be able to effectively change large numbers of data before I attach it, and I’d probably mess up the power query if I try to reference the new sheet.
So if I can’t get help without providing any attachments, I guess I’ll have to figure it out myself.
Thanks so much for the help, though. 🙂