Formula for same numbers in Excel

N

nikos

Hi.

I have 2 columns in Excel (C10:C200 and D10:D150) filled by numbers. How can
I find how many numbers in column D (and if it is possible which) included
also in the column C.
I would like to apply a formula and not any shorting method.


Thank you.
 
D

DILipandey

Hi Nikos,

To get the count of numbers in Column C, use following:-
=COUNT($C:$C)
& to know which one of them are there in column D, use following:-
=IF(ISNUMBER(MATCH($C:$C,$D:$D,0)),"Present in D", "Not Present")
and drag it down
Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
[email protected]
[email protected]
New Delhi, India
 
N

nikos

thank you both.

DILipandey said:
Hi Nikos,

To get the count of numbers in Column C, use following:-
=COUNT($C:$C)
& to know which one of them are there in column D, use following:-
=IF(ISNUMBER(MATCH($C:$C,$D:$D,0)),"Present in D", "Not Present")
and drag it down
Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
[email protected]
[email protected]
New Delhi, India
Click to expand...
 
N

nikos

and something more please.
If I wanted to find how many same numbers are only in C column ? (or else
how we can find the population of non unique numbers in a column)

Thanks again for yours time.
 
H

Harald Staff

Change D to C in my formula.
This said, I suspect that it's not the most practical solition. When and Why
is important here. I do most similar tasks with Pivot Tables.

Best wishes Harald
 
Top