I have created a template which provides recommendations, and the number of recommendations is very large. I would like to provide a summary sheet which provides an average of the text items (Red, Amber, Green) for each category. I know that you can do this via VBA, but where I am working they do not allow macro enabled excel workbooks! Therefore, i am try to find away to do this through a formula. I have looked around and cannot seem to get anything working, and would appreciate any help
I am also a fan of Excel tables / Listojects, as when used with formulas they automatically capture all the data, so any suggestions with ListObjects would be great
The detailed recommendations is something like the below:-
<tbody>
</tbody>
The summary would something like:-
<tbody>
</tbody>
The formula would need to only look at the rows for an individual category, then do the average
Thank you all in advance
I am also a fan of Excel tables / Listojects, as when used with formulas they automatically capture all the data, so any suggestions with ListObjects would be great
The detailed recommendations is something like the below:-
Category 1 | C01 | Red |
Category 1 | C01 | Amber |
Category 2 | CO2 | Red |
Category 2 | CO2 | Red |
Category 3 | CO3 | Green |
Category 3 | CO3 | Amber |
<tbody>
</tbody>
The summary would something like:-
Category | Average Rating |
Category 1 | Red |
Category 2 | Red |
Category 3 | Green |
<tbody>
</tbody>
The formula would need to only look at the rows for an individual category, then do the average
Thank you all in advance