Risk Matrix table using Content Controls

Dave T · #8 08-01-2018, 06:48 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
insert the 2 content controls into a Repeating Section in a table	smaccharoli	Word VBA	2	02-27-2018 08:49 AM
Duplicating one or more table rows or an entire table with content controls	kevinbradley57	Word VBA	10	08-17-2017 02:13 PM
2nd matrix gives a resut that doesn´t match numbers in the 1st matrix	Diver	Excel	25	02-22-2017 04:39 PM
Macro to save docx to doc that checks compatibility and converts content controls to static content.	staicumihai	Word VBA	4	10-12-2016 08:23 PM
Content Controls - Add Table Rows	dgiromini	Word VBA	1	04-11-2014 03:04 PM