Hello,

I have a spreadsheet with 8 columns of data. I am trying to figure out how automatically tally how many times each entry in the last column (H) exists in the previous 7 columns (A - G). Each entry in column H could only exist 1 time max in each of the other columns but doesn't have to exist in any columns.

Any ideas?

Roger