Originally Posted by

**Squeaky**
Hi ms38,

Here is my solution that does not require a button. In column A, put your check boxes and tie them to a cell. I used the B column to do that.

Column C has a simple true/false equation that will input the name of the item when TRUE.

The D column lists the row number from C when the check box is TRUE. The E column uses the SMALL function to organize the list without spaces. An ARRAY

formula can be used here but they can be slow. The F column will display the name of the item by indexing, using the row number in E. You can make the

list as long as you want and it will still work as long as you drag the formulas in D, E, and F down to as long as your list is. The results in column F

can be placed or mirrored anywhere on any sheet. Hide the cells you do not wish to see.

NOTE: If you add any rows above the first item in the list (CAT in mine) then you will need to adjust the formula in E. For the SMALL function to work properly,

you need a range of values and a number to designate which of the smalls you prefer. = small(range,number). 1 is the smallest, 2 is the second smallest, etc. In my equation I use the

row formula =row()-1 to get the first "small" item. =row() in E2 resolves to "2". I add the -1 to make it resolve to 1. I could have simply typed 1 there,

but then I would have to type 2, 3, 4 etc. in all of the formulas down the column. I prefer to write it this way so the formula can be dragged. I hope I was not confusing here.

## Bookmarks