create formula

  1. I

    Average IF in DAX

    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...
  2. 1

    How to move data from one cell into a different column but have the associated data attached follow.

    <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...
  3. A

    Need Formula that Calculates Sums of Multiple Cycles Within Column

    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...
  4. M

    Combining 2 cells to create a formula

    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've detected that you are using an adblocker.

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.
Go back
Back
Top