Question

This question was asked in Countif formula for counting duplicates
Isha Gupta's image

PLEASE PROVIDE THE EXCEL SHEET FOR THIS.