Results 1 to 5 of 5

Thread: Excel - counting instances of )

  1. #1
    Mod / Salary / SM Wanderer's Avatar
    Join Date
    2001-12
    Location
    St. Louis
    Posts
    5,406
    Login to Give a bone
    0

    Default Excel - counting instances of )

    This is a bit of an odd one, but, I need to count how many closing parentheses I've got in an excel column (and not just the number of fields in which it occurs, the total number, as there will be multiple occurrences per records).

    Any excel gurus have some advice on what my formula should look like?


    For the time being, I did a find/replace and replaced all ")" with ")q" as I didn't have any other q's on the page, but, using COUNTIF I only got the total number of records where the *Q* appeared (like 270), instead of the total number of Qs (which should be over 700).
    Melanie Stone
    @MistresDorkness

    Archibus, FMS/FMInteract and AutoCAD Expert (I use BricsCAD, Revit, Tandem, and Planon, too)
    Technical Editor
    not all those who wander are lost

  2. #2
    All AUGI, all the time CADastrophe's Avatar
    Join Date
    2012-01
    Location
    Site of the next CADaclysm
    Posts
    813
    Login to Give a bone
    0

    Default Re: Excel - counting instances of )

    Are you allowed to create a new analytical column?

  3. #3
    Mod / Salary / SM Wanderer's Avatar
    Join Date
    2001-12
    Location
    St. Louis
    Posts
    5,406
    Login to Give a bone
    0

    Default Re: Excel - counting instances of )

    Quote Originally Posted by CADastrophe View Post
    Are you allowed to create a new analytical column?
    I suppose I could. With these massive reports, I like to spend as little time processing them as possible. But, I only do them once a quarter, so I guess it's no big deal.

    should've known I'd get you in an excel topic. lol. thanks.
    Melanie Stone
    @MistresDorkness

    Archibus, FMS/FMInteract and AutoCAD Expert (I use BricsCAD, Revit, Tandem, and Planon, too)
    Technical Editor
    not all those who wander are lost

  4. #4
    All AUGI, all the time CADastrophe's Avatar
    Join Date
    2012-01
    Location
    Site of the next CADaclysm
    Posts
    813
    Login to Give a bone
    0

    Default Re: Excel - counting instances of )

    Quote Originally Posted by Wanderer View Post
    I suppose I could. With these massive reports, I like to spend as little time processing them as possible. But, I only do them once a quarter, so I guess it's no big deal.

    should've known I'd get you in an excel topic. lol. thanks.
    The easiest way to do this would be to create a separate column to count the characters of each line and get the total of that column. Assuming that your data resides in column A, I think that I'd fill column B with the following formula:

    =LEN(INDIRECT(CONCATENATE("A",ROW())))-LEN(SUBSTITUTE(INDIRECT(CONCATENATE("A",ROW())),")",""))

    This formula results in the difference of characters between the original text and the text without the specified character.

  5. #5
    Mod / Salary / SM Wanderer's Avatar
    Join Date
    2001-12
    Location
    St. Louis
    Posts
    5,406
    Login to Give a bone
    0

    Default Re: Excel - counting instances of )

    Quote Originally Posted by CADastrophe View Post
    The easiest way to do this would be to create a separate column to count the characters of each line and get the total of that column. Assuming that your data resides in column A, I think that I'd fill column B with the following formula:

    =LEN(INDIRECT(CONCATENATE("A",ROW())))-LEN(SUBSTITUTE(INDIRECT(CONCATENATE("A",ROW())),")",""))

    This formula results in the difference of characters between the original text and the text without the specified character.
    Holy cannoli, you're a flippin genius. That worked a treat!

    Thank you, Corey!
    Melanie Stone
    @MistresDorkness

    Archibus, FMS/FMInteract and AutoCAD Expert (I use BricsCAD, Revit, Tandem, and Planon, too)
    Technical Editor
    not all those who wander are lost

Similar Threads

  1. Replies: 11
    Last Post: 2012-12-14, 09:29 PM
  2. 2012: Counting no of feature instances in a part
    By sanganaksakha in forum Inventor - General
    Replies: 4
    Last Post: 2012-08-21, 08:53 AM
  3. Replies: 2
    Last Post: 2012-01-31, 07:02 PM
  4. Counting Characters
    By BeKirra in forum AutoLISP
    Replies: 4
    Last Post: 2009-03-16, 02:59 AM
  5. counting blocks
    By b_v_mc in forum AutoLISP
    Replies: 9
    Last Post: 2005-01-20, 07:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •