Need help in solving formula type or VBA function to copy only checked check boxes into new cell. I have used the True / False statement and it copies information correctly. The problem occurs when 5 check box options available and only 1 and 3 are selected. I need a formula or method to list only the checked items in a new rows without blank rows between selected items:
CK:B1=APPLES
__:B2=ORANGES
CK:B3=PEARS
__:B4=GRAPES
__:B5=FIGS
A100 =IF(A1=TRUE,B1,IF(A2=TRUE,B2,IF(A3=TRUE,B3),IF(A4=TRUE,B4,IF(A5=TRUE,B5,"")
A101 =IF(A2=TRUE,B2,IF(A3=TRUE,B3),IF(A4=TRUE,B4,IF(A5=TRUE,B5,"")
A102 =IF(A3=TRUE,B3),IF(A4=TRUE,B4,IF(A5=TRUE,B5,"")
A103 =IF(A4=TRUE,B4,IF(A5=TRUE,B5,"")
A104 =IF(A5=TRUE,B5,"")
RESULT:
A100 = APPLES
A101 = PEARS
A102 = PEARS
A103 =
A104 =
DESIRED RESULT:
A100 = APPLES
A101 = PEARS
A102 =
A103 =
A104 =
Bookmarks