P
psd364
I need to use a formula to find out how many times the value in B2 appears in
column B.
column B.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lars-Åke Aspelin
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
T
Tom Hutchins
psd364 said:I need to use a formula to find out how many times the value in B2 appears in
column B.
T
Tom Hutchins
Try
=COUNTIF(B:B,B2)
in any cell not in column B on the same sheet.
Hope this helps,
Hutch
=COUNTIF(B:B,B2)
in any cell not in column B on the same sheet.
Hope this helps,
Hutch
S
Shane Devenshire
Excel 2003 does allow full column references with the COUNTIF function.
S
Shane Devenshire
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?
of the COUNTIF function, do you really want to do that?
L
Lars-Åke Aspelin
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