leaves

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...

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...

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...

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...

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...

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...

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!!

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...