excel help

  timber 15:28 24 May 2003

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


  VoG™ 15:31 24 May 2003

Enter this formula


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

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


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