# Choice List

#### eddieRoberts

##### New Member
I have a list in one worksheet.
To choose things on this list I place an "x" next to them.

What formula can i use to take just the CHOSEN items from the list mentioned above and have them apprear on another worksheet within the same workbook.

Thank you

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### Barry Katcher

##### Well-known Member
Assuming your list is in sheet 1, column A and your "x" in column B, on Sheet 2, cell A1, enter:

=IF(SHEET1!B1="x",SHEET1!A1,"")

Copy this down as far as you need. To print, first AutoFilter for "non-blanks".

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,623
Messages
5,838,422
Members
430,546
Latest member
CometOz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back