Hey,
What I need is to make an average of all the numbers under heading A (there are 3 in the example), but the calculation will be by line rather than column.
For example: At Sarah's row, the new column will sum up the numbers 5+10+10 because they are under a header that contain the letter...
<colgroup><col><col><col><col></colgroup><tbody>
Smith
Jen
Breakout_Session_1
I can read with my eyes
smith
Jen
Breakout_Session_2
Wedo
smith
Jen
Breakout_Session_3
App Safari
Black
Kay
Breakout_Session_1
Multimodal Magic
Black
Kay
Breakout_Session_2
Digital Pets
Black
Kay...
Hey everyone. I'm currently a student and my studies have nothing to do with excel, but I have am in the middle of an internship where all I do is work with spreadsheets. Currently, I'm working with a paper company in Alabama, where they asked me to create a spreadsheet that measures efficiency...
I need to combine the contents of 2 cells into a formula that will return the value of a named cell, eg
I have a cell named - "ees007"
Cell A1 = ees
Cell B1 = 007
I need a formula which will combine A1 and B1 to return the value of cell "ees007"
I'm sure there's a simple solution but I'm...
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.