+ Reply to Thread
Results 1 to 5 of 5

Formula to Find Total Number of Different Value Variations

  1. #1
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Question Formula to Find Total Number of Different Value Variations

    Hello,
    I need a formula that list the total number of each number combination found in column A in column E, which would correspond with the number values sorted in column C.

    See the below for examples.

    Column Formula Breakdown
    A: contains number combinations

    B: contains either win, loss, or break even.

    C: contains the sorted combinations from column A

    E: contains the total number of each combination found in column A and entered next to the sorted variation in column C

    F: percentage of time the variation in column C appears amongst all variations

    H: contains the total number of “wins” for each combination found in column A and entered next to the sorted variation in column C

    I: percentage of time the “wins” of this number combination in column C appears amongst all variations

    K: contains the total number of “losses/break evens” for each combination found in column A and entered next to the sorted variation in column C

    L: percentage of time the “losses/break evens” of this number combination in column C appears amongst all variations

    Please see spreadsheet for a better understanding.

    Any and all help you could provide for any of the formulas would be greatly appreciated. Thank you.
    Attached Files Attached Files
    Last edited by artiststevens; 06-07-2014 at 05:17 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: Formula to Find Total Number of Different Value Variations

    Is this what you're looking for?
    Attached Files Attached Files
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

  3. #3
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Re: Formula to Find Total Number of Different Value Variations

    Amazing! That's exactly what I'm looking for! Thank you very much it is greatly appreciated. :-) The system won't let me rep you again so fast but as soon as I can I will. Thank you for helping solve both problems.

  4. #4
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: Formula to Find Total Number of Different Value Variations

    Haha, that's funny. I didn't know there was a time limit on +Repping the same user. I guess it makes sense to avoid people making a second account to +rep themselves. You're welcome. Glad I could help

  5. #5
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Re: Formula to Find Total Number of Different Value Variations

    Quote Originally Posted by k64 View Post
    Haha, that's funny. I didn't know there was a time limit on +Repping the same user. I guess it makes sense to avoid people making a second account to +rep themselves. You're welcome. Glad I could help
    Lol yep... but I just repped you now. Thank you again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] validate 1 item has 5 variations; if not add missing variations
    By ccampbell14 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2013, 03:03 PM
  2. Macro to find variations on a search value
    By edbyford in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2012, 06:01 AM
  3. Find total time taken by each person to process total number of letters.
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2010, 10:04 AM
  4. number variations
    By aint much cop in forum Excel General
    Replies: 3
    Last Post: 07-16-2005, 09:05 AM
  5. [SOLVED] a formula to find total compound amount after given number of yea.
    By ronan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2005, 05:06 PM

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