Hi All, I want to send my people to different suppliers for inspection and want to identify if there are any conflicts with dates. The data look like below. I need a formula which will check date column and inspector column as one criteria for a particular supplier and return number of conflicts in "conflicts" column. So if there are more than on occurrences of same date and inspector then I need to know the number of occurrences. I hope I am describing it properly. any help will be much appreciated
<tbody>
</tbody>
Supplier | Date | Inspector | Conflicts |
A | 01-Sep-14 | AD | 1 |
B | 01-Sep-14 | XY | |
C | 01-Sep-14 | AD |
<tbody>
</tbody>