Saturday, February 12, 2005
Permutations and Combinations in Excel
These are two great functions in excel.
Combinations
The syntax is =COMBIN(Number, Number_chosen). The number is how many things you have. Eg 3 sandwich spreads. The number chosen is how many you want to combine. For example how many different combinations of 2 sandwich spreads can you make when you have 4 spreads available. The formula is =COMBIN(4,2) and the answer is 6 different combinations of two sandwich spreads.
A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from combinations, for which the internal order is not significant.
So the number total number of permutations you can make from 4 objects using 2 objects.
from this formuls =PERMUT(4,2) and the answer is 12.
The Excel Guru's Free Tips and Hints.
Welcome
Welcome to the Excel Tips blog. Free Microsoft Excel Tips and Hints designed to increase your productivity.
Advertisement
Subscribe Me
Previous Posts
- Using Excel to make pretty pictures
- Working out a persons Age in Excel
- Using the sheet name in an Excel file
- Using Conditional Formatting to flag due dates in ...
- Double uses for buttons on Excel Toolbar
- Protection in Excel Spreadsheets
- Changes to selecting all cells in Excel 2003 from ...
- New Zealand Excel Website
- Trick custom formats in Excel
- Arithmetic Operations in Excel
My Blogs and Websites
- Spy Journal Home
- Spy Journal Archives
Personal Blog- Excel Tips Blog
- Blog Tips Blog
- Tech Tips Blog
- Urban Space Novel
- Photo Archive
- Parklife Results
- Parklife Soccer Club Website
- KROSTech LAN Parties
- Jethro Management
- Jethro Consultants
- Oz Bush Poet
Excel Links
- ---RSS Feeds---
- Unofficial Microsoft Office Stuff
- KC on Exchange and Outlook
- Office Zealot
- Automate Excel
- Colo's Excel Junk room
- Daily Dose Of Excel
- The Planning Deskbook
- Excel Pragma
- Andrew's Excel Tips
- ---No RSS Feed---
- Excel Tip
- Mailbarrow
- Experts Exchange
- AJP Excel Information
- Beyond Technology
- Contextures
- ExcelTip
- Mr Excel
- Pearson Software Consulting
- Peltier Technical Services
- John Walkenbach - J-Walk
- Vangelder (wont work in Firefox)
- VBA Express
- xlDynamic
- The Excel Nexus
- Code Net
- Better Solutions
- Excel Business Tools
- Data Pig Technologies
- VBA Express
Other Links
Copyright Notice. All documents and text contained in this web site www.spyjournal.biz and sub pages is copyright material of Jethro Management (c) 2004 unless noted as being copyright material of someone else. No public reproduction of the content on this site in any form is permitted without express written permission.
Unless otherwise expressly stated, all original material of whatever nature created by Tim Miller and included in this weblog and any related pages, including the weblog's archives, is licensed under a Creative Commons License.