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