Thanks for your immediate response. The file I uploaded was only a sample. My actual file has more 10,000 rows and it is not easy to drag or copy for 10,000 rows. Also, this requirement has to be implemented repeatedly for multiple projects. So the best would be a formula which can calculate unique text values with multiple criteria.