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

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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