Forum Discussion

DylanBrown's avatar
DylanBrown
Copper Contributor
Dec 13, 2023

Moving Text Based on Cell Sum

Morning,   I'm trying to figure out how I can move text based off a number.   As you can see there are 5 points on the left hand side, next to each is a column for S (Severity) and L (Likel...
excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 13, 2023

Hi DylanBrown 

 

This might not be exactly what you want (yet) as I'm not sure I understood '...to show on average what the figures are'

 

You'll see in attached file (in Name Manager) a formula named AvgInitialAssessment that does the AVERAGE of all numbers in [R]. If this isn't what you meant please explain how you want to calc. this average

 

Also, in table 'Additional Control Measures' I used old style formulas as you did not mention the version of Excel you run. If you run 2021 or 365, instead of a table this can be reported as a dynamic array

  • DylanBrown's avatar
    DylanBrown
    Copper Contributor
    Dec 14, 2023
    Morning,

    Thanks, this is what I needed and it works as I need it too.
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Dec 14, 2023

      Hi DylanBrown 

       

      There was a glitch in the initial version I posted. I uploaded a revised version later. Just in case re-download and if this does what you want there's a link at the bottom of the post to Mark as solution (helps people who Search) Thanks

Resources