leaves

  1. gmooney

    Pivot Table Calculation for Sub Totals

    I have the below pivot table with 2 value columns that I need for any subtotals (in this example Romaine Leaves is the sub total of the 5 rows) to calculate the weighted average of the 5 rows (the math for this is the 3 columns to the right of the pivot table. Instead of 10.9 showing for Average...
  2. P

    Totally confused in Leave days & Earned days

    Hi, :confused: Confused have put a lot time on below but couldn't find Solved it sadly ;( I have a Senior hopefully might we can Solve below situation with formula. Ever employee has number of Paid laves in his account. But those paid leaves can't be availed all at once. Only allowed or can...
  3. K

    Attendance

    https://www.dropbox.com/s/r3p63j9aeshtiq9/test.xlsx?dl=0 Hi, I'm trying the following requirements from the attached excel and not getting. Can anyone please help. 1. Every month should be added 2 in CL column automatically based on date criteria. (I used today() with IF function). 2. If...
  4. srizki

    Please correct, =IF(ROW(A3)>$B$1,"",INDIRECT($A$1&"!"&ADDRESS(ROW(A3),COLUMN(A3))))

    Cell A1 has a drop-down list of sheets name, Cell B1 has, =MATCH(9.99E+307,INDIRECT(A1&"!A:A")) From Cell A3 down and across, =IF(ROW(A3)>$B$1,"",INDIRECT($A$1&"!"&ADDRESS(ROW(A3),COLUMN(A3)))) The problem is that there are some blank cells or rows that gives 0 zeros, How can I update the...
  5. T

    Cell Formating with Conditions

    I am looking to use cell formatting as such: If the number is less than zero, then 0.0; if the number is greater than 999.99, then 999.99, otherwise pull leave the number as is. I have been able to get half way there with #,##0.0;"0.0" . This makes the negative numbers = 0.0 but still leaves...
  6. C

    Excel Attendance File Query

    I am trying to add leaves other than specified in the image, but i am unable to add in the formula cell NJ8. I am using W for indicating Work from Home, but i dont want to get these to be counted for Leaves this month COlumn (NJ) and Leaves This Year Column (NK). Also Work From home can be...
  7. B

    InputBox Error if left blank or cancel is selected

    Hey all! I have been trying to figure out the code to give an error message when the user leaves it blank or hits cancel with no luck. Thanks for the help!!
  8. T

    Remove Duplicates Leaves the wrong data I need last row not first?

    HI Everyone, I have this Macro that removes duplicates great Sub Macro2() ActiveSheet.Unprotect ActiveSheet.Range("$A:$N").RemoveDuplicates Columns:=Array(2, 9, 10), _ Header:=xlYes ActiveSheet.Protect End Sub The only problem is it leaves the first row not the...

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