Excel 2010

Posted on 2011-10-31
Last Modified: 2012-06-22
I want to know how often a field in a column is in that column?  This is text data.
Thanks for your time.
Question by:darlene_shepherd
    LVL 31

    Expert Comment

    by:Rob Henson
    Sounds like you can use the COUNTIF function.


    Rob H
    LVL 13

    Accepted Solution



    LVL 31

    Expert Comment

    by:Rob Henson
    Ooops, typed the parameters the wrong way round.

    Should be as NG has quoted.

    Range - would be the column in which you are looking
    Criteria - the text value that you are looking for.

    Rob H

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now