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 advancetimber
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.
VoG™Once again mate thanks a lot just what I was looking for and replied to very quicktimber
This thread is now locked and can not be replied to.
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
© Copyright 2017 IDG UK. All Rights Reserved.