Help with concatenate
In one worksheet I have checkboxes set up for a true/false value (if
checkboxes are checked then a violation has occurred) , when checked it sends "true", when unchecked it sends "false" to column A in another worksheet that corresponds to the violation in column B. In the same worksheet, if column A has a true, it takes the corresponding violation in column B and will put them in a cell. The formula reads all of those that are marked true. I would like to take all of those that come up as true and put them in one cell. Sometimes 1 box will be checked (1 violation) or it could be 15 boxes checked (15 violations). If I ask for it to read the range of cells, I am getting an error message if all cells aren't filled in with a violation. |
Help with concatenate
What formula? What type of the error message? Please post your formula and
your expectation of the result. "Riversage" wrote: In one worksheet I have checkboxes set up for a true/false value (if checkboxes are checked then a violation has occurred) , when checked it sends "true", when unchecked it sends "false" to column A in another worksheet that corresponds to the violation in column B. In the same worksheet, if column A has a true, it takes the corresponding violation in column B and will put them in a cell. The formula reads all of those that are marked true. I would like to take all of those that come up as true and put them in one cell. Sometimes 1 box will be checked (1 violation) or it could be 15 boxes checked (15 violations). If I ask for it to read the range of cells, I am getting an error message if all cells aren't filled in with a violation. |
All times are GMT +1. The time now is 07:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com