Choice List

[eddieRoberts]

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

 

[Barry Katcher]

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".