Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

combin function returning results in excel

Status
Not open for further replies.
RandDUser

RandDUser

Technical User
Feb 24, 2005
65
0
0
US
I have 8 objects that I have to group in all possible pairs of 2. Using the formula, COMBIN(8,2), the result is 28 possible combinations. Is there any way for the formula, or an other formula to return those 28 results?

thanks!
 
Sort by date Sort by votes
No - but you could build them in an 8x8 table to view - you will find tha as you populate the table there is a pattern making it easier to populate.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
514
Andrzejek
Andrzejek
arvarr
  • Locked
  • Question
Excel - getpivotdata function 2
Replies
3
Views
58
arvarr
arvarr
Bijugate
  • Question
Excel update question
Replies
0
Views
106
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
133
combo
combo
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
103
Andyri
Andyri

Part and Inventory Search

Sponsor

Back
Top