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

## Bookmarks