excel help

  timber 15:28 24 May 2003
Locked

have a column with name places in cells.
is there any formula that I can use to find out exactly how many times a given place name has been entered.


thanks in advance



timber

  VoG™ 15:31 24 May 2003

Enter this formula

=COUNTIF(A2:A5,"placename")

substituting the range of data for A2:A5 and the place name you want to count instead of placename.

  timber 15:38 24 May 2003

VoG™
Once again mate thanks a lot just what I was looking for and replied to very quick

timber

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone