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:
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:
Thank you!


Aucun commentaire:
Enregistrer un commentaire