Here is a bit a of a challenge...
Say I have some days of week marked in cells by an "X", and a cell where I am currently entering the days of service.
I am looking for a formula in days of service cell that examines the cells to its left for an "X", and derives a concatenated list of the correct days
Thanks
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>
Say I have some days of week marked in cells by an "X", and a cell where I am currently entering the days of service.
I am looking for a formula in days of service cell that examines the cells to its left for an "X", and derives a concatenated list of the correct days
Thanks
Mon | Tue | Wed | Thu | Fri | Days of Service |
x | x | Tuesday, Thursday |
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>