Here's one guess at it ..

Assume the data below is in Sheet1,
in cols A to F, data from row1 down

05l.jpg 106.jpg 543.gif 106.jpg 37l.jpg 106.jpg
12l.jpg 246.jpg 106.jpg 112.jpg 002.bmp 107.jpg
37l.jpg 1141.jpg 413.gif 37l.jpg 1141.jpg 109.jpg
etc

In Sheet2
------
Put in A1: =COUNTIF(Sheet1!$A1:$F1,Sheet1!A1)-1

Copy A1 across to F1, fill down to cover as many rows
as there is data in Sheet1

Sheet2 returns the count of matches that each data item in Sheet1 has with
the other items on the same row. A zero return means the data item in Sheet1
is unique within that row. For the sample data, the results would be:

0 2 0 2 0 2
0 0 0 0 0 0
1 1 0 1 1 0

Adapt to suit if the above is close to what you're after ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"David" wrote in message
...
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.