A 3

D 6

E 6

A 1

A 5

B 9

C 4

D 6

E 4

A 15

C 1

C 6

E 3

D 6

B 2

E 5

B 5

C 1

Hi Mr Excel(lent!) Need a formula to calculate occurrences between A,B,C,D,E excluding repeats: (Example) A2 cell D, A8 cell D (E,A,A,B,C) separate the rows. B2 cell 6. Exclude A B2 would equal 5. A6 cell B (C,D,E,A,C,C,E,D) separate rows B6 cell 9. Exclude the repeats (C,D,E) B6 cell would equal 5. etc, etc.