Comparing integer lists

  • Thread starter Thread starter edb
  • Start date Start date
E

edb

I have to compare two columns of integers in excel, and count how man
of the integers in column 1 also appear in column two.

The columns are sorted in decending order, and no number will appea
twice in the same column.

I can achieve this using a long macro but am trying not to do this.

I have =COUNTIF(J12:J111,D12) working so that if the value in D1
appears within J12-J111 then a count takes place, but I have no ide
how to make this now go onto comparing D13,D14,D15 etc...

Thanks for any help!
E
 
Thanks Trevor, this is certainly one solution, but I was really hopin
for a method which would enable one formulae in one cell to calculat
the number of repeated integers in the two columns. I'm not sure i
"countif" is the best to use, or if there is another way.
Anyways, at least this works.
E
 
Hi
try the following array entered formula (entered with
CTRL+SHIFT+ENTER):
=SUM(COUNTIF(J12:J111,D12:D111))
 
Back
Top