vendredi 16 mars 2018

Formula that creates a list based on cell value

I have a list of employees that choose different insurance coverages in a workbook. I am looking to make a formula that creates a list based on whether a cell has a value or not (column B).

Here is how my workbook looks:

enter image description here

I have tried the following formula:

{=IFERROR(INDEX($A$2:$A$9,SMALL(IF(B2="<>""",ROW($A$2:$A$9)-(ROW($A$2)-1)),ROWS($1:1))),"")}

Here is the answer I am seeking:

enter image description here

Thank you!

Aucun commentaire:

Enregistrer un commentaire