Number combinations

B

bmag

New Member
Joined
Nov 29, 2011
Messages
4
In column A, I have number different combinations in each first cell, each combination has 5 numbers ranging from 1-30, i have the numbers separated by just a space. Is there a way to select the cell range in column A, and find different number combinations, for example: how many times the numbers 1 and 15 appear together in a sequence? This is how each cell looks:

1 11 12 15 28
2 5 6 17 29
3 8 19 21 22
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
First, insert four new (blank) columns to the right of your data. Then highlight your column with the data and do a text-to-column with a space as your delimiter. You now have each number in its own column, which makes everything a lot easier.
 
Upvote 0
-- removed inline image ---
ok this is what it looks like now, if i highlight my five columns, is there a formula to determine how many times the #1 and #7 are in a sequence?
 
Upvote 0
6-random-and-unique-numbers3.png


I believe it would be a Countif function, say i wanted to know how many times 1 and 32 appear "in the same row", not just how many times they appear by themselves.
 
Upvote 0
Yes. I would say to do a COUNTIF function in the next column then total the column.
 
Upvote 0
Here's two ways, one using the space-delimited in one cell, the other reading values across five columns:


Excel Workbook
ABCDEFGHIJK
11 11 12 15 28*1111215281st value2nd valueColumn AColumns B:F
22 5 6 17 29256172913222
33 8 19 21 2238192122
41 4 5 32 351453235
532 32 32 32 323232323232
61 1 1 1 111111
71 7 32 1 8173218
Sheet1


HTH
Adam
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Excel Formula to build out Combinations/Permutations of a series of numbers
Replies
1
Views
198
Eric W
Eric W
W
  • Question Question
[Excel 365] Maximizing unique combinations of words - No repeats between any two words
Replies
4
Views
350
waffle
W
A
  • Question Question
Changing row number dynamically in link to another file
Replies
1
Views
202
AlphaFrog
AlphaFrog
L
  • Solved
Combinations of 3 from 16 numbers pool with unique product
2
Replies
14
Views
653
libelouli
L
Y
  • Solved
Need formula to match
2
Replies
10
Views
641
yukonexcel
Y

Forum statistics

Threads
1,223,970
Messages
6,175,710
Members
452,667
Latest member
vanessavalentino83

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top