1. L

    advanced filter - OR vs AND

    Hi Please I need your help to understand Advanced filter. In the example below, the author said to use advanced filter that means to use OR condition. and he created the criteria and found this I understood all the above but what I do not understand, when I use a regular filter to filter...
  2. B

    What are Class Modules

    Hi, I am new to MS Access and have never used Class module in Excel VBA either. My question is more regarding Access, can anyone please help me understand what are class modules. How they are different from regular modules. What are the advantages of a class module or why and when should we...
  3. R

    Changing Font Type in Header VBA Code

    Hello Everyone, I'm getting some odd behavior when I try running some VBA code that updates the font type in a page header. Here is the snippet of code: With masterWkbk.Worksheets("Dashboard") .PageSetup.RightHeader = "&""Times New Roman,Regular" & Format(Now, "YYYY") & " " & prevQtr &...
  4. T

    if then statment

    I need a formula that will look at the dates in a column and if between X and Y then sum(range) I am working on calculating quarterly totals, so I want it to look in colA for date between 01/01/2019 and 03/31/2019 then add that range totals from column E col A Col B...
  5. T

    Returning multiple values based on multiple parameters

    Please help! I am struggling so bad! I am trying to run 4 potential values. C11 can contain "Mini" or "Regular" Mini = 5.50 Regular = 6.50 BUT If H11 contains "Lays","BBQ","Doritos", then add .50 to total. So if they select one of those options, the total then becomes 6.00 for a Mini &...
  6. A

    How to make a DAX measure NOT to re-calculate on aggregated levels?

    I have a DAX measure which works perfectly on the level 0 POV in the Pivot Table but I was wondering if there is a way to make it aggregate like a regular number when filtering to top level POV (e.g. instead of looking at July or August, look at Year Total)? The problem is the aggregated number...
  7. J

    Formula for Calculating Overtime and Premium Time

    Hello, I'm looking for a formula that will multiply a value based on the time codes of Regular (no multiplier), Overtime (1.5 multiplier) and Premium(2 multiplier). The download from our accounting software displays as follows: <colgroup><col><col></colgroup><tbody> Type Hours...
  8. T

    SUMPRODUCT with multiple criteria in Rows and Columns (Still function as SUMPRODUCT instead of SUM or COUNT)

    Hi, I have a query related to SUMPRODUCT with multiple criteria in Rows and Columns. Using the below example to explain the problem. I have data of sales figures of various products belonging to different categories for different quarters over a few years. Am trying to calculate the...
  9. M

    Need an alternative non-volatile formula

    Hello,</SPAN></SPAN> For now using in the cell C5 following formula, is there any replacement of this non-volatile formula to regular formula </SPAN></SPAN> <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse...
  10. H

    Reference Row with Cell Value

    Hi - I know how to do this with VBA, but is there a way to do it with a "regular" formula. So something like if C1 = 27 the Formula would be sum (A&C1:A100) which would sum A27 to A100.
  11. I

    Help with Script, error in hourly calculations

    I posted this a few weeks ago, as i was working with the data, i noticed that some of the hourly calculations were not correct. To shed some light on this, here is what i am trying to do: I have the following headers: A=Payroll Company B=Code Payroll Name C=File Number D=Payroll Pay Date...
  12. H

    How to make automated hour calculation

    Im trying to build a way, how to derive from overtime hours regular working time. The rationale is that the regular working hours would be clearly visible. Example: I enter overtime work info 18:00-21:00 (3 hours), and excel calculates that work start time must have been 09:30 and end time...
  13. S

    Ok... what's with this minus sign?

    So I have a data set that I import off of a website. The positive numbers look good. But this minus sign is double the size of a regular negative. Website value: –0.13% Regular value: -0.13% I've tried to do find and replace, but that doesn't work. The problem is, I use the copy / paste...
  14. D

    Measure column - summarization

    Hello guys, I have a matrix with some measure columns that creates some conditions. That´s the Delta_classification. Delta_classification =...
  15. H

    Hour Tracking with Multiple Overtime Tiers and Shift Premiums

    Hi, I'm putting together a timesheet for my company and I'm having a bit of trouble doing hour totaling. On the same sheet I have rows for different job numbers and columns for days of the week. I also have 2 sections on one sheet, one relating to regular time worked and one relating to hours...
  16. I

    Add a value and an offset value

    Hello, Trying to loop through the B column and when there's a certain string I want to enter a fixed value in column H, but when it's case REGULAR DELIVERY PV I also want to add the value of the j column to the fixed value. I know I need to do an offset but my code doesn't seem to work. Please...
  17. I

    VBA Case Select Multiple Conditions

    Hello, I'm trying to do a case statement in VBA. If the value in J is >= 200 AND <300 I want it to say in O REGULAR DELIVERY PV, when >= 300 AND <400 I want it to say REGULAR DELIVERY PV300, and when >= 400 REGULAR DELIVERY PV400. This does not work. Sub VolumeChange() '...
  18. R

    How to keep grouping in multiple pivot tables?

    Hello, I created groups in my regular pivot table, but now I want to create a power pivot. Is there a way to carry-over my grouping from the regular pivot table into the power pivot without recreating it? Thanks, RCAAA
  19. E

    Premium shift pay formula?

    Hello. I have been going thru the payroll videos and I was trying to see if there is a video on shift premiums? Unless I missed it, maybe? I want to find a formula where a special shift premium is added to the employees pay from 7:00 pm to 1:00 am. The employee may actually start their shift...
  20. R

    How to calculate Regular working hours and Over time

    Hi, I am facing issue to get the result of Regular hours and over time based on the following conditions. Input is as: A1 = Start Time B1= End time Conditions as: <tbody> Regular hours Over Time (1x) Over Time (1.5 x) Over Time(sunday- 1.5x) Over Time Sunday(2x) 8:00 AM to 5: PM 6:00 AM...

Some videos you may like

This Week's Hot Topics