View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BCBC
 
Posts: n/a
Default Formula to show all items with an "x" next to them

On Sheet 1, I have several check boxes spread out across several rows and
columns. Next to each check box is a description - to make it easy I'll call
them "shoes", "hats", "gloves", and "rutabagas". I'm looking for a formula I
can use on a separate sheet that will show all of the checked items separated
by commas. For example, if someone placed checks next to hats, rutabagas, and
gloves, the formula on the next page would display "hats, rutabagas, gloves".
Is there such a formula?