+ Reply to Thread
Results 1 to 2 of 2

Formula to Count Frequency of Reoccurring Number Combinations

  1. #1
    Registered User
    Join Date
    04-22-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    1

    Formula to Count Frequency of Reoccurring Number Combinations

    Hi,

    I have a spreadsheet that looks like this:

    A1

    234
    456
    925
    432
    546
    123

    Is there anyway to find out how many times a combination of numbers occurs regardless of the order? So in the example the combination of numbers 2,3,4 occurs two times (234 & 432). I can separate the numbers into 3 columns if that helps in any way. Any suggestions would be greatly appreciated.

    Thanks

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: Formula to Count Frequency of Reoccurring Number Combinations

    calculate unique sum for combinations a look for them
    Attached Files Attached Files

+ 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. Count the max frequency of a number
    By congthanh6868 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-19-2014, 07:24 PM
  2. Count a reoccurring number divisible by 70 over 24 months.
    By warrenjns in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-08-2014, 11:45 AM
  3. Replies: 3
    Last Post: 02-11-2014, 05:36 PM
  4. Sum of reoccurring names in a column ? Need to count each name only once..
    By syncguy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2012, 08:44 PM
  5. Return number with highest frequency count
    By Archibald_SM in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2011, 06:14 PM
  6. Replies: 4
    Last Post: 03-02-2011, 12:38 PM
  7. How do I count the frequency of a given number in a column?
    By dykstra_sj in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-02-2006, 04:35 PM

Tags for this Thread

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