Hello,
I was running a worksheet in office 365 but now only have access to Excel 2016. The TEXTJOIN formula is incompatible with Excel 2016.
The formula I was using was ="• "&_xlfn.TEXTJOIN(CHAR(10)&"• ",TRUE,IF(risks[Likelihood]=$C3,IF(risks[Impact]=D$8,risks[Title],""),""))
This formula plots the name of the risk on a chart depending on it's probability score and impact score. See attached for the visual.
The formula allows for multiple risks to be inputted in a single cell.
Can this still be done without the TEXTJOIN Function?
Here is a link to the video explaining the formula in more depth. How to create risk map in Excel - Charting Tip
Here is a link to a downloadable file. Free Excel Risk Map Template » Project Management » Chandoo.org
I was running a worksheet in office 365 but now only have access to Excel 2016. The TEXTJOIN formula is incompatible with Excel 2016.
The formula I was using was ="• "&_xlfn.TEXTJOIN(CHAR(10)&"• ",TRUE,IF(risks[Likelihood]=$C3,IF(risks[Impact]=D$8,risks[Title],""),""))
This formula plots the name of the risk on a chart depending on it's probability score and impact score. See attached for the visual.
The formula allows for multiple risks to be inputted in a single cell.
Can this still be done without the TEXTJOIN Function?
Here is a link to the video explaining the formula in more depth. How to create risk map in Excel - Charting Tip
Here is a link to a downloadable file. Free Excel Risk Map Template » Project Management » Chandoo.org