Can someone please help with providing a formula which generates a list of text values in multiple columns which satisfy a certain criteria (i.e. a '1' in the row) and ignores the blank cells.
Example below:
<tbody>
</tbody>
So creating a formula which would generate a list of Name1, Name5, Name8 and Name10. I will have to repeat this formula for 100+ rows in spreadsheet.
Sorry if this is really simple, but I've spent a lot of time googling to no avail.
Thanks
Example below:
NAME1 | NAME2 | NAME3 | NAME4 | NAME5 | NAME6 | NAME7 | NAME8 | NAME9 | NAME10 |
1 | 1 | 1 | 1 |
<tbody>
</tbody>
So creating a formula which would generate a list of Name1, Name5, Name8 and Name10. I will have to repeat this formula for 100+ rows in spreadsheet.
Sorry if this is really simple, but I've spent a lot of time googling to no avail.
Thanks