I need to use a formula to find out how many times the value in B2 appears in
column B.

On Fri, 14 May 2010 12:38:08 -0700, psd364
wrote:

I need to use a formula to find out how many times the value in B2 appears in
column B.


Try this formula:

=COUNTIF(B:B,B2)

or, if you don't have Excel 2007, use this

=COUNTIF($B$1:$B$65536,B2)

Hope this helps / Lars-Åke

Excel 2003 does allow full column references with the COUNTIF function.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Lars-Ã…ke Aspelin" wrote:

On Fri, 14 May 2010 12:38:08 -0700, psd364
wrote:

I need to use a formula to find out how many times the value in B2 appears in
column B.


Try this formula:

=COUNTIF(B:B,B2)

or, if you don't have Excel 2007, use this

=COUNTIF($B$1:$B$65536,B2)

Hope this helps / Lars-Ã…ke


.

On Fri, 14 May 2010 16:24:01 -0700, Shane Devenshire
wrote:

Excel 2003 does allow full column references with the COUNTIF function.

Thanks for pointing that out. I wasn't sure so I gave an alternative
solution too, just in case full column reference was not allowed.

Lars-Åke

"psd364" wrote:

I need to use a formula to find out how many times the value in B2 appears in
column B.

Try
=COUNTIF(B:B,B2)
in any cell not in column B on the same sheet.

Hope this helps,

Hutch

"psd364" wrote:

I need to use a formula to find out how many times the value in B2 appears in
column B.

Be careful B2 is in the range B:B so you will be counting the criteria cell
of the COUNTIF function, do you really want to do that?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"psd364" wrote:

I need to use a formula to find out how many times the value in B2 appears in
column B.