Microsoft Excel = list all unique combinations in "sets" HELP!?

Answer The following macro will generate all the combinations and list them in range E1:H495. Your list of 12 items is assumed to be in A1:A12. You may need guidance on how to copy and run the macro:Sub... Read More »

Top Q&A For: Microsoft Excel = list all unique combinations ...

How do I convert a Microsoft Excel list to a Microsoft Access list?

Clean Up the Excel DataRemove any blank rows or columns and make sure each column contains only one type of data. For example, one column has first names, the second column last names and so forth.... Read More »

How to Get a List of the Unique Values in an Excel Spreadsheet?

In Microsoft Excel 2007, there are 3 basic ways to view and/or generate a list of unique values, including using an advanced filter, removing duplicates or applying conditional formatting. The meth... Read More »

How to Sort a List in Microsoft Excel?

This article explains the basics of how to sort a list using Microsoft Excel. Just follow these simple steps to reorder your lists however you need. The examples in this article use a simple list, ... Read More »

How do I use Microsoft Excel to create a mailing list?

PlanningThink about the information for each contact that needs to be captured. The more information about a contact that you choose to track, the more useful this set of data can become in the fut... Read More »