Combine text from multiple cells if other cell has a value of 1
Closed
shenton
Posts
1
Registration date
Thursday October 29, 2015
Status
Member
Last seen
October 29, 2015
-
Oct 29, 2015 at 11:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Oct 29, 2015 at 12:20 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Oct 29, 2015 at 12:20 PM
Related:
- Combine text from multiple cells if other cell has a value of 1
- Tentacle locker 1 - Download - Adult games
- Combine notifications viber - Guide
- Igi 1 download - Download - Shooters
- Fnia 1 apk - Download - Adult games
- Fnaf 1 download pc - Download - Horror
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Oct 29, 2015 at 12:20 PM
Oct 29, 2015 at 12:20 PM
Hi Shenton,
Try the following formula:
=IF(B2=1,$B$1&", ","")&IF(C2=1,$C$1&", ","")&IF(D2=1,$D$1&", ","")
There is going to be a comma space (, ) at the end of the string.
To remove that use the following formula:
=LEFT(F2,LEN(F2)-2)
Or combine the 2 by replacing both F2 references from the second formula with the first formula.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Try the following formula:
=IF(B2=1,$B$1&", ","")&IF(C2=1,$C$1&", ","")&IF(D2=1,$D$1&", ","")
There is going to be a comma space (, ) at the end of the string.
To remove that use the following formula:
=LEFT(F2,LEN(F2)-2)
Or combine the 2 by replacing both F2 references from the second formula with the first formula.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
