I like to Count text using excel formula, example:
A B C D
1 EQR/G/022/02/14
2 EQR/N/020/02/14
3 EQR/S/007/02/14
4 EQR/G/019/02/14
5 EQR/N/023/02/14
6 E-MAIL
7 E-MAIL
8 EQR/G/040/02/14

Where the answer should be 8, where E-MAIL can be counted more than one, and the other should be counted only once if the pattern is the same.

Thanks