Jul 23 2021 11:42 AM
Jul 23 2021 05:34 PM
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
Jul 24 2021 01:16 AM
Jul 24 2021 01:23 AM
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
Jul 24 2021 01:27 AM
Jul 24 2021 01:56 AM