Forum Discussion
Excel Formuła Multiple Building selections, Consolidated in one Cell
So I am at a loss of what forumla to use. I have sent out a spreadsheet to my team that has 5 different buildings. I put the building names as the column header at top. If those individuals selected ...
There are always--ALWAYS--multiple ways to get to solutions in Excel. And one key in figuring out which of the multiple ways is the better (or best) is to know how the data are arrayed, what the process is to use that data, what is expected by way of output. Although you've given a bit of a description (names of buildings across column headings), we don't really get a full image of the rest of it.
Is it possible, therefore, for you to post a copy of the actual workbook--just making sure it doesn't reveal any data that should be confidential (create a facsimile if necessary)--posting that working workbook on OneDrive or GoogleDrive with a link pasted here that grants access.