Results 1 to 7 of 7

Finding # of Occurrences in various cells.

Threaded View

The Exceller Finding # of Occurrences in... 08-13-2010, 09:16 AM
arthurbr Re: Finding # of Occurrences... 08-13-2010, 09:28 AM
The Exceller Re: Finding # of Occurrences... 08-13-2010, 09:39 AM
arthurbr Re: Finding # of Occurrences... 08-13-2010, 09:46 AM
Marcol Re: Finding # of Occurrences... 08-13-2010, 09:48 AM
arthurbr Re: Finding # of Occurrences... 08-13-2010, 09:48 AM
The Exceller Re: Finding # of Occurrences... 08-13-2010, 10:02 AM
  1. #1
    Registered User
    Join Date
    04-29-2010
    Location
    McLean, VA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    87

    Finding # of Occurrences in various cells.

    I have attached a spreadsheet which has various codes typed into a number of cells.

    I am trying to find the number of occrrences for certain codes that appear in these cells. The problem is that the codes in the cells look as follows:

    cell A13: 272.4;789.01;787.23;401.9;274.9;2725
    cell A18: 530.3;787.20;041.86;578.1;455.6;565.0


    That appears in one cell itself and the codes are separated by a semicolon.

    What I need to do is find the number of occrrences that a certain code occurs. For example, how many times does 787.20 (from above) occur in the entire list from cell A5:A164?

    It is difficult to siphon out certain numbers because they are all lumped together and separated by the semicolon.

    I've attached the spreadsheet for ease of understanding.

    I've tried to use the =countif function but it won't pick up everything it should because of the semicolon problem and the numbers being lumped together.

    Any help is much appreciated!
    Attached Files Attached Files
    Last edited by The Exceller; 08-13-2010 at 10:07 AM. Reason: [SOLVED]
    The Exceller
    If I helped you, please add to my reputation by clicking on the scale by my name in this post.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1