Combine in Excel
Combine
in Excel
This
function calculates the highest number of combinations available based upon
a fixed
number of items.
The
internal order of the combination does not matter, so AB is the same as BA..
Microsoft
Excel Function
=COMBIN(HowManyItems,GroupSize)
Formatting
No
special formatting is needed.
Content
Data
Pool
Of Items
|
Items
In A Group
|
Possible
Groups
|
|
5
|
2
|
10
|
=COMBIN(C4,D4)
|
3
|
3
|
1
|
=COMBIN(C5,D5)
|
15
|
2
|
105
|
=COMBIN(C6,D6)
|
Combine in Excel
Reviewed by Rupesh
on
11:35
Rating:
Reviewed by Rupesh
on
11:35
Rating:
No comments: