+ Reply to Thread
Results 1 to 2 of 2

Results based on subdata

  1. #1
    Registered User
    Join Date
    06-25-2008
    Posts
    3

    Results based on subdata

    I know this title isn't exactly very descriptive but, it was the best I could come up with.

    I would like to calculate a percentage for the whole based on the result of its parts. Each sample I have has a varying number of sub samples. Now i could do this all by hand but, with around a thousand samples that would be just slightly tedious. Below is a piece of sample data to look at.

    Sample Data

    In that case I want to know the percentage of positive results for sample 0701950 and also 0701951. Positive results are anything with a result of "P", "R", "S", or not having an "-". I figured a SumProduct forumla would do it but becuase of the sub sample numbering that proved a mightly challenge for me. I tried to use the "*" wildcard but excel doesn't seem to recognize it or I used it incorrectly. I'd like to be able to just click/drag the formula so it auto fills for all my samples without having to adjust it for each new set as well. I'm hoping one of you here are much more cleaver then I when it comes to this .

    Thanks in advance for any help you can offer.

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    a helper column with left(a1,7) is a choice for you
    I need your support to add reputations if my solution works.


+ Reply to Thread

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