Is there a formula I can use to match a file name in one column with any
matches in other columns and give a total count for each column?

Example:
A B C D E
F
05l.jpg 106.jpg 543.gif 106.jpg 37l.jpg
106.jpg= 0 in column A, 1 in column B, 1 in column C, 2 in column D etc etc€¦

12l.jpg 246.jpg 106.jpg 112.jpg 002.bmp 107.jpg= 0
in column A, 0 in column B, 1 in column C, 0 in column D etc etc€¦

37l.jpg 1141.jpg 413.gif 37l.jpg 1141.jpg
109.jpg= 0 in column A, 0 in column B, 1 in column C, 0 in column D etc etc€¦

69l.jpg 351.jpg 107.gif 002.bmp 084.bmp
112.jpg= etc. etc€¦

35l.jpg 112.jpg 109.jpg 106.jpg 124.bmp
1141.jpg= etc. etc...

Any suggestions, ideas would be greatly appreciated. Thank you.