calculate

  1. D

    DAX filter on two tables

    Hi, I'd like t filter by two tables, very simply I have : Green and 10+ :=CALCULATE([Total Units]...
  2. Ferreira1456

    Dates with condition using userForm textBox in VBA

    Hello everybody, can you help me? If I delete the value of txtPrazoPagamento or the value of txtDateVencimento. I get this message: Run-time '13' Type mismatch Private Sub txtDataVencimento_Change() If CDate(txtDataHoje) > CDate(txtDataVencimento) Then txtAtraso.Value = Abs(DateDiff("d"...
  3. W

    If calculation to only count either positive or negative volumes

    Hi. I'm trying to create a formula for cells D2 and E2 that looks at the original position less the change but only if it impacts the positive or negative side of zero accordingly. For instance, in the example below the original starting position was positive 10 but due to a change of negative...
  4. D

    Run macro if cell (formula) in column meets condition

    Hi All, I am working on a work order tool where I have in column (P) a formula that pops up different phases/stages. Now I am trying to start a macro automatically when the stage changes to "Gereed". I have tried a couple of things like worksheet_change and worksheet_calculate, but so far no...
  5. H

    Automate calculations when adding new column of data

    Regularly, I get a excel file with P&L monthly actuals. I create 7-8 columns at the end of the spreadsheet that does calculations based on the data that is provided. Is it possible to create a macro that will calculate the data set when I copy and paste new columns?
  6. J

    Search data and calculate with VBA UserForm

    Hi everyone, its my first time using VBA and any sort of coding in general so I have been cracking my head for weeks trying to do this UserForm . I'm wondering if there is anyone here that could help me with it? Any help is appreciated, Thank you in advance!! I have 2 main issues that I've been...
  7. A

    100k lines - Copying Name LookUp Value from Sheet 1 to Sheet 2 Efficiently

    Greetings, Need some help with an automation script - possibly a loop with variant arrays? Couldn't put it in practice, but it seems to be the consensus for faster data parsing. I've got a convoluted 25 sheet workbook that we use to determine the price for certain products. The Product Names...
  8. M

    Can I sum text values like numbers from a single cell?

    Below is a screenshot of a workbook with a sample of what I am trying to do. I have a sheet with a tab labeled "MATERIALS". The sheet contains a list of materials in column A and in column B is the corresponding value of the materials On a second sheet with the tab labeled "PROJECTS" I have a...
  9. K

    Matrix Visualization with data from same source filtered by 2 separate date filters

    I have a data source with sales data by store. Columns in this data include actual sales, forecasted sales, week date, weekending (saturday), region for the store, and which warehouse the store received the sold items from. I need to create a matrix visualization in which the user can filter the...
  10. H

    calculating overtime

    So I have a spreadsheet to keep track of my time at work. It goes In - Out, In - Out, Total (time I clock-in in the morning then out at lunch then back in after lunch and out for the day). My total time formula for the day is represented as =SUM(B1-A1)+(D1-C1). My cell format is [h]:mm and so...
  11. G

    PowerPivot CALCULATE SUM

    Hi, would appreciate any help with this, I'm trying to do a calculate sum if in PowerPivot, example of how it workls in Excel below, but am unsure how to replicate in PowerPivot. Thanks in advance for any help. Gav.
  12. S

    Calculating the age during operation as an integer

    Hello there I only know the birth dates of the patients. I am trying to learn their age as an integer from a fixed operation date. 1965 birth date 3.3.2015 operation date Which formula can I perform this calculation with excel 2010? thanks
  13. S

    Adopting page filters in a report for calculate DAX expressions

    Hello I am facing a problem with filters when using a calculate function. To paraphrase an example, say I have a table of sales with a date and a sale method of either internet or store. In a second table, I would like to create a monthly summary of the number of sales - so I create a date...
  14. G

    To calculate based on names

    Hi Everyone, Here i am trying to calculate the value based on the headers which are in the "sum" sheet and their names will only be A,B,C......, and my inputs are in "main" sheet but in my input those columns will be renamed as Sum of A,Sum of B,Sum of C..........., and my preferred output...
  15. S

    Comparing two date cells

    Hi I have a date in K (11/11/2019 17:20:35) and a date in D (11/11/2019) I want to calculate if D was after or not on K. My formula is =IF(K1<=D1,"yes","no") This seems to work, expect in this example, where the dates are the same. Because the time is also in K, is doesn't see it as a...
  16. G

    Calculate Future Due Date

    I would greatly appreciate any suggestions to help solve the problem listed below which uses the table shown below: <tbody> A B C D E F G H 1 TODAY IS: 11/06/2019 2 3 PAYEE FIRST DUE DATE AMOUNT REPEATS EVERY X PERIODS UNTIL NEXT DUE DATE 4 Chase...
  17. megera716

    Calculate # of months between two dates

    I know this is such an easy one, but I'm not getting the desired result and there's a lot of complicated formulas out there that are throwing me off! I just want to calculate the difference between month numbers. So April (4) and October (10) is 6. September (9) and October (10) is 1. December...
  18. S

    Formula not calculating

    Hello All, Lately I have been having certain formulas fail to calculate (yes, I AM on automatic calculation ;)). On November 2, it was a simple =Today() function that hadn't updated since October 31. Hitting calculate or refresh did nothing. Only when I entered the formula for editing, then...
  19. P

    How best to add category to age

    Hello- I have data as this: How would be cleanest way to do this. to populate the blank column Name age Category Joe 19 Sue 24 Berli 10 I would l calculate the age category so that age <12 = child 12-17 - Adolescent 18+ = adult Name age category Joe 16...
  20. C

    How to calculate conditional median without accessing worksheet function?

    I have a large set of data and I need to calculate the median of certain values which are based on certain conditions in an if statement in a loop - in the code below I need to calculate the median of all the value_1 fields - does someone have code that can be used to calculate a median like...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top