Hello,
I am trying to have a formula which takes an average of a column of B from a range that is controlled by another cell.
For example:
=AVERAGE(B(N7):B(N8))
where if N7 has a value of 100 and N8 has a value of 200 the outcome would be:
=AVERAGE(B100:B200)
Thank you in advance
Hi all, need some syntax help here. I have these 3 lines of M code shown below (they're part of a larger query):
#"Remove % from Load Factor Name" = Table.RenameColumns(#"Merge Periods with Comma",{{"Load Factor%", "Load Factor"}}),
#"Divide Load Factor by 100" = Table.ReplaceValue(#"Remove %...
I'm trying to set up a default value for a text box. It will be a file path that contains an ampersand.
Everytime the form is loaded the text box evaluates the ampersand and so it disappears.
C:\J&B changes to C:\JB and so the subsequent code doesn't run.
Is there a way to escape the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.