ExcelBanter - Count dublicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count dublicates (https://www.excelbanter.com/excel-discussion-misc-queries/243909-count-dublicates.html)

Bogi

Count dublicates

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

Eduardo

Count dublicates

Hi,
try

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

change range to fit your needs

"Bogi" wrote:

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

Bogi

Count dublicates

Thanks a lot

"Bogi" wrote:

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

Bogi

Count dublicates

Thanks a lot

"Eduardo" wrote:

Hi,
try

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

change range to fit your needs

"Bogi" wrote:

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

All times are GMT +1. The time now is 01:07 AM.