database formula

  1. A

    Calculating Sumproduct across different months

    Hi - I have three acquisitions which will occur in different months (i.e. one in Feb; one in Apr etc): <colgroup><col><col span="6"></colgroup><tbody> Timing of Acquisitions Jan Feb Mar Apr May Jun Acq1 1 Acq2 1 Acq3 1 </tbody> When acquired, each acquisition...
  2. E

    Pulling data from multiple sheets onto master in certain cells, vlookup?

    I am starting to work on costing and margin analysis in apparel. I need to create a formula or macro to help pull data across multiple tabs/sheets in one workbook into certain cells of another workbook or tab (depending on what is easiest) I'm only average in excel so I am open to input as to...
  3. T

    Database formulas not recalcing

    Hi, I am using database formulas (dmax sitting within an offset formula). My model is set up to manually calculate, the formulas are on hidden rows on a sheet which is protected - I don't think these things would be relevant to my issue but they are worth mentioning. What I am finding is that...
  4. T

    dmax/dsum etc horizontal selection criteria?

    Hi guys, I'm wondering whether its possible to set up the selection criteria relating to a databse formula horizontally (i.e. in cells A1 and B1) rather than vertically (in cells A1 and A2)? It would be very helpful for my model given my dsum / dmax formulas run down a page (so at the moment...

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