aladin

  1. F

    SUMPRODUCT by Aladin is not working again

    i have uploaded the file here https://www.dropbox.com/s/j491r6e5s6in3qu/Aladin.xlsx?dl=0 below formula does not work. =SUMPRODUCT(DataAMOUNT,--ISNUMBER(MATCH(DataYear,B$2)),1-ISNUMBER(MATCH(DataMonth,$A3,0)),--ISNUMBER(MATCH(LEFT(DataPRODUCT),{5,6,7}&"",0)))
  2. E

    converting from formula to text or paste special

    Hi There, I have put in a formula in excel until column z and for 70 row from sheet 2 Is there a way to convert formula into text so that no one see my formula? Vba is also fine
  3. J

    Summing a dynamic range to match a precise given total.

    A3 is where I input a decimal number which changes quarterly A2 is a factor which I also input quarterly B3 is (A2*A3)/12 This goes on for A3>A6 and B3 through B6 I do this because I do not know B3 through b6 as individual values but I am given their sum in B7 which I can enter as well but...
  4. J

    Aladin's 3 columns

    Hi all if I have three columns of text that I want listed into one column what function would I use? I'm partially using this: http://www.mrexcel.com/archive/Formulas/28674.html in his example, how would I make a fourth column combining all the others>?

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