formula as text

  1. C

    Excel Formula Explanation Required

    Hi All, I have been asked to explain the following formula: =IF($C22=$C21, "", AVERAGEIF($C:$C,$C22,D:D)) If anyone could break down what this formula is calculating, I would be very grateful. Thanks
  2. C

    Complex Formula - Explanation Required

    Hi All, I have been given a task at work and it is to explain the following forumla: =IF($C11=$C10, "", MAX(OFFSET($E$1,MATCH($C11,$C:$C,0)-1,0,COUNTIF($C:$C,$C12)))) All that I know about this is that this formula is taking the average of several cells that have a certain textual...
  3. P

    Indirect() won't work with a formula entered as Text?

    In J14: ='[Alan Beta Strat Bond and GBO 25th February.xlsx]MULTISECTOR Front Sheet'!$B$2 (Formatted as Text) In A2: =INDIRECT(FilePath) Note: Range("J14") Named as Filepath Why am I getting #REF! This is not the right way?

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