Hello Paul,
Just one more question...
I have further completed the form and have added a table cell that should return the highest residual risk from the last column (Risk (ii) i.e. column 9).
I have this working in Excel using the following formula:
=IF(COUNTIF($J$11:$J20,"High")>0,"High",IF(COUNTIF ($J$11:$J20,"Significant")>0,"Significant",IF(COUN TIF($J$11:$J20,"Moderate")>0,"Moderate",IF(COUNTIF ($J$11:$J20,"Low")>0,"Low",""))))
I know the range in the formula above would need to manually adjusted depending upon the number of rows used or I could use a dynamic named range, but how can this be done in Word using content controls for an unknown number of rows ?
Regards,
Dave T
|