Count dublicates

B

Bogi

I have three colums with data. I would like to count dublicates that are in
all colums.
Can somone help
Thanks
 
N

NBVC

If you mean you only want to count items that appear in all
columns...

then try something like:

=SUMPRODUCT(--ISNUMBER(MATCH(A1:A5,B1:B5,0)),--ISNUMBER(MATCH(A1:A5,C1:C5,0)))

where A1:C5 is the data range of the 3 columns... adjust as necessar

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com
 
Top