finding number in column

[mcsim]

i like to know how many time number that is in one column appear in another column .

thanks

 

[Andrew Poulsom]

If the number is in cell A1 and the list in in range B1:B10, type this foemula in any other cell:

=SUMIF(B1:B10,A1)

 

[Aladin Akyurek]

On 2002-10-13 07:37, mcsim wrote:
i like to know how many time number that is in one column appear in another column .

thanks

Let A2:A10 be the first vertical range and B2:B10 the second.

In C2 enter & copy down:

=COUNTIF($B$2:$B$10,A2)