Count dublicates

[Bogi]

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

 

[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

 

[Bogi]

Thanks a lot

 

[Bogi]

Thanks a lot

Hi,
try

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:A100,B1:B100,0))))

change range to fit your needs