leave

  1. W

    Need Help with Array Formula to return multiple results for specified criteria

    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: Selected Employee Selected Year Only Leave Types: Call Off, In Late, Leave Early The first formula I tried with the leave type conditions but it said I was...
  2. W

    Struggling with nested functions

    Can someone please help me to write the following formula? Conditions: if A1 and B2 are blank and A2 and B1 are NOT blank If True: = A2 If False: (leave cell blank)
  3. A

    How to stop entries in excel if it’s value above the set of target

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

    Access: On Load On Current

    When a Form is loaded is it also considered "On current" or does the user have to leave the form and come back to it to be on Current?
  5. A

    Modifying Training due date based upon Leave date

    Hello, 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...
  6. T

    Help, i'm stumped

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

    Case sensitive sumproduct

    Hello, 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: <tbody> Leave Name Code Sick Leave S...
  8. U

    Annual Leave Database - A-Z Sorting, Repeated Lists and User Access

    Hi all 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...
  9. V

    today's date leave blank

    Hello all 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
  10. O

    I want to include the hyperlinks from the table I am Importing using Power Query

    Hi, 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...
  11. I

    Code for character allowance in cell

    Morning, 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 Example, So i type in cell B9 15...
  12. S

    Cleaning Data - HELP!

    Hi, 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...
  13. M

    VBA Code for TextBox & SpinButton To set Time Format

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

    Excel Leave validation

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

    Help with existing code

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

    Detect fill colour in cells

    I have a conditional formatting that shades cells based on my criteria, however if the cell already as shading I want to leave it as is. How can I do this please? Thanks
  17. E

    Is it possible to remove links from a workbook?

    When I open a workbook, it asks to connect to links. Is it possible to remove them and just leave the values in? Thanks
  18. N

    Complex formula to calculate an end date with rules - Please HELP!!

    Hi Guys, I'm new to excel and I took up a time sensitive assignment assignment and I really appreciate any help on this. <tbody> Start date (input) Eligible Months (input) Age 50 (Input) Age 55 (input) Rule62 (input) Age 62 (Input) Leave end date 06/1/2019 12.5 7/1/2014 07/1/2019 09/1/2019...
  19. S

    Formula for Annual Leave

    Hello, 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...
  20. M

    VBA Copy Paste Special certain columns of a table?

    Hi all 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) or remove all formulas and leave...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top