In order to perform this operation, you will need at least two sheets open in your workbook: a working sheet and a blank sheet where you can compile your lists. The first step is to create your list.

In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on that data. It's a handy program to have if ...