B
Benjamin Barreto
Hi, I Hope you can help me with this:
If I have a row full of data(False or True text) in every
column and I want to put in one cell the number of the
colums when is true separated by commas.
For example:
A B C D ......
TRUE FALSE TRUE TRUE
by any formula what I need is the number of the columns
separated by commas all in one cell
1,3,4
Thanks
If I have a row full of data(False or True text) in every
column and I want to put in one cell the number of the
colums when is true separated by commas.
For example:
A B C D ......
TRUE FALSE TRUE TRUE
by any formula what I need is the number of the columns
separated by commas all in one cell
1,3,4
Thanks