A survey was conducted to identify the type of movies watched by 15 people in the past two weeks. If the type of movie watched by one person is different from the others, then the code 1 will be assigned to that movie by the database. If they are the same, the database assigns the number of the duplicate. An example is shown in the following table. The first four people watched the same movie, so the codes are assigned from 1 to 4, and so on. Explain how to assign the correct code using an IF function.

Transcribed Image Text:

1 2 3 4 45 A B Type of Movie Repeat Code Action Action Action Action 6 7 8 Comedy 9 Drama 10 11 Drama Comedy Comedy Drama 12 Drama 13 Drama 14 Drama 15 Drama 16 Drama 1 2 3 4 1 231234567 8