Excel 2007 : Countif using 3 columns to 3 colums.

[markDuffy]

Hi everyone

I have used countif (got an excellent lesson here) with one column. IE =COUNTIF($A$2:$A$85000,$D$2:$D$85000) Then de duplicating a column I get the result.
I now have three columns and I want to do the same with them. What I did was =COUNTIF($A$2:$C$85000,$D$2:$E$85000) which returns 0
I can always use the first and then split up the result manually. This is a pain as this is one of many lists and I will be at it all day and tomorrow.

Attached one spreadsheet.
Columns A B C main list
Columns D E F deduped list
Column G result of =COUNTIF($A$2:$A$85000,$D$2:$D$85000)
Column H result of =COUNTIF($A$2:$C$85000,$D$2:$F$85000)

I show the result of sorting by largest first in columns O using the same data copied into I to N. (just to point out the issue

And what I would like in column P

hope this all makes sense.
Mark