Hello All,
So I want to return a text value based on 4 criteria. I can do this with the Index Match function, however I want to concatenate ALL text values found in the column that match the 4 criteria into a single cell seperated by "; ". I desperately need help on this! The data would look like below as a sample (Columns A,B,C,D,E)
<TBODY>
</TBODY>
I want the audit names concatenated into a single cell if Region="Asia", Type="Internal", Status="Complete", and Month="January". Therefore, the result in the cell should read "APAC; Korea GO". If I just have the function then I would then have the usability to search other criteria, etc.
Any help on this would be greatly appreciated!
-Taylor
So I want to return a text value based on 4 criteria. I can do this with the Index Match function, however I want to concatenate ALL text values found in the column that match the 4 criteria into a single cell seperated by "; ". I desperately need help on this! The data would look like below as a sample (Columns A,B,C,D,E)
Region | Type | Status | Audit Name | Month |
Asia | Internal | Complete | APAC | January |
Asia | Internal | Complete | Korea GO | January |
Europe | External | Complete | UK sheffield | January |
<TBODY>
</TBODY>
I want the audit names concatenated into a single cell if Region="Asia", Type="Internal", Status="Complete", and Month="January". Therefore, the result in the cell should read "APAC; Korea GO". If I just have the function then I would then have the usability to search other criteria, etc.
Any help on this would be greatly appreciated!
-Taylor