excel formula array

  1. K

    How to Get Period-wise Stock

    @ How to Get Period-wise Stock N3 =SUMIFS(E:E,C:C,L3,D:D,M3) ( IN) O3 =SUMIFS(J:J,H:H,L3,I:I,M3) (OUT)
    • krunal123
    • Thread
    • #combination #conditional formatting #excel #comparison #excel #expert #excel #formula #confused #excel #minimum #index #excel #pivot #excelproblem #match #if condition #inventory #inventoryreporting #powepivot #powerquery #reference #sumifs exce formula excel formula array pivot table stock balnce
    • Replies: 7
    • Forum: Excel Questions
  2. S

    Include values of cells as an array in a formula ????

    It has been a while since I posted. I have a formula that references some values in a range. The range is static and the values are constant. The formula is in cell E3. I would like to remove the values from the range and hard code them into the formula so that I don't have to have the values...
  3. S

    Complex Formula was working, now failing

    I have a complex formula that was previously working for the last 6 months. Now when I try to run it, it just gives me a #VALUE ! error. The data set over the last 6 months and now is basically the same volume. I haven't change the formula, the layout of the columns, tab names, nothing ...
    • spydey
    • Thread
    • #value! error excel formula array formula previously run
    • Replies: 2
    • Forum: Excel Questions
  4. D

    Excel - I need the ROW formula to go to the next row, while i drag across.

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...
    • DV1987
    • Thread
    • 1px; drag excel formula array formula row11
    • Replies: 2
    • Forum: Excel Questions
  5. C

    need some quick help for a work project

    I am trying to even see if this is possible. I am familiar with excel but not an expert just general work use. I have an excel with a list of 18 names in column A and column b has yes or no and i want c1 for example to list the names in column A that have a no in column b. Either together in...

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