Formula for same numbers in Excel

  • Thread starter Thread starter nikos
  • Start date Start date
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.
 
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.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
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.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
Click to expand...
 
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.
 
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
 
Back
Top