Hello Excel Users!
I need some assistance on an array formula for a summary table that will show multiple results for a set of criteria:
Only Leave Types: Call Off, In Late, Leave Early
The first formula I tried with the leave type conditions but it said I was...
Hai , can any one help me to solve this issue Am creating one leave plan template , I want to restrict the entry if the leave is crossing above the target .
In my template row is employee names and column follow dates, And for leave plan i put code for leave as “V” and total count by using...
I've below two sets of data in different excel sheets
1) Training data - it contains User ID, Training Start date and Training Due date
2) Leave data - it contains User ID, Leave Start date and Leave End date
User can have multiple training which are assigned through out the year and...
Just looking for a little help with this formula as I cant seem to get it to work. Basically I'm looking to return an F if the "PP - 3" is greater than 0. Returning a P if "pp - 1" + "PP - 2" is greater than 0 and if when you add all three together it returns a 0 then leave the cell bank.
I have a problem with a formula in a staff holiday tracker.
The tracker has the employees names in Coloumn A, from row 6 to row 15.
Coloumns B-NI correspond to the days of the year: each employee enters the leave codes, as per the table below:
I have been asked to make a chart for staff in an office. Currently there are approximately 111 members of staff, however this is likely to increase in the coming months. I have prepared a workbook which has sheets for 2019 and 2020. Each of these sheets has the days of the year across...
Can I have some help please on this
I want to include in the formula below
[IF TODAY() > TODAY () Leave blank
[Range("C23:P34").FormulaR1C1 = "=SUMIFS(Sales!C9,Sales!C5,R21C,Sales!C16,R22C,Sales!C21,R4C3,Sales!C24,RC2)"
Is this possible please
I have used iqy files for excel on mac. It loaded the table results and i was able to format it but it left the hyperlink as needed. I decided to try power query and used my windows version of excel and I am able to make the connection and pull the data. Much easier to deal with. But the...
I am looking for a code which will show a msgbox to advise me the character count in the active cell is anything but 17
Some info for you.
Worksheet is called MC LIST
The code will only need to work for column B
The range would be B6 & down the page
So i type in cell B9 15...
I need urgent help to develop a formula for the following:
I have an extremely large data set, approximately 600,000 rows. There are a number of variables that need to be considered but basically I need to delete positive and negative numbers (hours paid) per employee (employee id), per...
Hi can anyone tell me if it’s possible to have a two TextBox 1&2 with two SpinButton 1&2 that sits in a userform so when the user presses the SpinButton 1 it drops a time format into say cell A1which would be known as leave and by pressing SpinButton 2 it drops a time format into say cell A2...
Hello Everyone ,
I am trying to create an excel application for leave, I have got the template online and its perfect for me.
I want to create a validation while applying leave and need your help for this.
While applying for leave the system checks the employee column (Employee are divided...
Hi can anyone please help I have the following VBA Code that works great but what I know would like to do is rather than the code copy the first 4 cells on a row when I double click, let’s say cells A1-A4, can the code not touch and leave cell A3 alone . So even if I was to modify the code...
Hi Guys, I'm new to excel and I took up a time sensitive assignment assignment and I really appreciate any help on this.
Start date (input)
Eligible Months (input)
Age 50 (Input)
Age 55 (input)
Age 62 (Input)
Leave end date
I am working somewhere that i am entitled to 2 days off per week whenever i am taking 1 day off per week 1 day needs to be added to my annual leave whenever I am taking 3 Days off per week 1 Day needs to be deducted
so i am looking for a formula that will count in an array of 7 cells...
Wonder if someone can help.
I have a table where some columns are formulas I want to keep and some are formulas I want to overwrite with their values (paste special to remove formulas).
I have code to either leave the table alone (leave all formulas)
remove all formulas and leave...