+ Reply to Thread
Results 1 to 3 of 3

What is the formula to calculate the number of combination?

  1. #1
    Forum Contributor
    Join Date
    08-25-2020
    Location
    Taiwan
    MS-Off Ver
    MS 365+win 10(64bit)
    Posts
    183

    What is the formula to calculate the number of combination?

    Can someone please help me with that one? It would be much appreciated.Thanks in advance

    Example Item 2
    Types of fruits Apples,Oranges (User input)
    The A supplier can provide two kinds of fruits Apples and Oranges
    The C supplier can provide two kinds of fruits Apples and Oranges
    The D supplier can provide two kinds of fruits Apples and Oranges
    So Total 3 Number combination
    Attached Files Attached Files
    Last edited by metrostar; 09-16-2020 at 02:12 AM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: What is the formula to calculate the number of combination?

    Please try at H2
    =IF(COUNTA(E2:G2),SUMPRODUCT(--(MMULT(COUNTIFS($B$2:$B$12,E2:G2,$A$2:$A$12,REPT($A$2:$A$12,MATCH($A$2:$A$12,$A$2:$A$12,)=ROW($A$2:$A$12)-ROW($A$1))),{1;1;1})=COUNTA(E2:G2))),"")
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    08-25-2020
    Location
    Taiwan
    MS-Off Ver
    MS 365+win 10(64bit)
    Posts
    183

    Re: What is the formula to calculate the number of combination?

    Bo_Ry you are great! Grateful! thank you
    it works perfectly for the data i provided

+ 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. Replies: 9
    Last Post: 11-19-2019, 05:28 AM
  2. Replies: 7
    Last Post: 01-25-2016, 08:10 AM
  3. [SOLVED] Formula or VBA or Combination to count Number of Cells in a merged range! PLEASE HELP!
    By WaylettChris in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-13-2014, 11:02 AM
  4. IF, AND, OR combination + how to calculate two deviations in same formula
    By JohnChoint in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-28-2014, 05:12 AM
  5. Replies: 1
    Last Post: 07-18-2013, 10:11 AM
  6. Need Validation formula for a Letter Number Combination
    By Talo in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-19-2012, 12:22 PM
  7. Replies: 0
    Last Post: 01-05-2005, 09:14 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