You can compare two similar Excel lists as done in https://yadi.sk/d/x46nsoCwaXQo9.
Enter the comparable lists under the shots and drag the "Take coincidence" button. Beyond the repetitions will appear the number of lines from the list opposite.
Enter the comparable lists under the shots and drag the "Take coincidence" button. Beyond the repetitions will appear the number of lines from the list opposite.