Prev: create an expense requisition form
Next: Date and Time
From: psd364 on 14 May 2010 15:38
I need to use a formula to find out how many times the value in B2 appears in
column B.
From: Lars-�ke Aspelin on 14 May 2010 15:45
On Fri, 14 May 2010 12:38:08 -0700, psd364
<psd364(a)discussions.microsoft.com> 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


From: Tom Hutchins on 14 May 2010 15:54


"psd364" wrote:

> I need to use a formula to find out how many times the value in B2 appears in
> column B.
From: Tom Hutchins on 14 May 2010 15:56
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.
From: Shane Devenshire on 14 May 2010 19:24
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
> <psd364(a)discussions.microsoft.com> 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
>
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: create an expense requisition form
Next: Date and Time