Create a new column called ‘Distributor New’ using these rul…
Create a new column called ‘Distributor New’ using these rules: If a movie’s distributor has released at least 30 movies in the dataset, list the original distributor name. If a movie’s distributor has released fewer than 30 movies, list ‘Other’. If the distributor field is blank/missing, also list ‘Other’. Steps to complete this task: First, create a lookup/reference table showing each distributor and their individual movie count. Then use a nested function formula combining to populate the ‘Distributor New’ column. The Distributor New for Waterworld is:
Read Details