Data counting problem

G

GlitchCog

I have a column of numbers 1 through 3000. Another column has a few
numbers scatered throughout this range. I want to have a third column
that runs the entire height of 3000 cells with either ones or zeros
corresponding to the first column where if the number exists in the
second column it gets a one and if it doesn't it gets a zero. Can
anybody help me? I've been looking into CountIf stuff, but I can't seem
to get the criteria to be any of the numbers in column 2. Thanks in
advance.
 
R

RagDyeR

If I understand what you're looking for, try this in C1:

=--(A1=B1)

And drag down to copy.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I have a column of numbers 1 through 3000. Another column has a few
numbers scatered throughout this range. I want to have a third column
that runs the entire height of 3000 cells with either ones or zeros
corresponding to the first column where if the number exists in the
second column it gets a one and if it doesn't it gets a zero. Can
anybody help me? I've been looking into CountIf stuff, but I can't seem
to get the criteria to be any of the numbers in column 2. Thanks in
advance.
 
R

RagDyeR

Just re-read your post and see where you mention "Countif".

It's easier to use this formula then to sit there and count the ones, or
create *another* formula to count the ones when this would do the *entire*
job:

=SUMPRODUCT(--(A1:A3000=B1:B3000))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


If I understand what you're looking for, try this in C1:

=--(A1=B1)

And drag down to copy.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I have a column of numbers 1 through 3000. Another column has a few
numbers scatered throughout this range. I want to have a third column
that runs the entire height of 3000 cells with either ones or zeros
corresponding to the first column where if the number exists in the
second column it gets a one and if it doesn't it gets a zero. Can
anybody help me? I've been looking into CountIf stuff, but I can't seem
to get the criteria to be any of the numbers in column 2. Thanks in
advance.
 
Top