based on

  1. P

    IFERROR formula help

    Hi All I have a column (in sheet called worksheet column E - starting in row 2) with all names, including duplicates. I wish to make a list in a seperate sheet in column A with only the unique values (each name once in this list - starting in row 6). This list must also look at the value in...
  2. P

    Hide cells if month different from previous cell

    Hi. I have searched but didn't find anything similar. Found some posts about dates but nothing like what I am searching for. My question: We work with a worksheet to register quality issues occurred during a certain month. The sheet is printed out a few days before the start of the new month...
  3. B

    Conditional Format based upon another cell

    Hi, I need some help. How do I place a conditional format for one cell that is based upon the value of another cell. i.e. - A1 turns red if A2 is greater than 2. Thanks, Chris.
  4. K

    Subtotaling based on date in a column

    I am trying to create a subtotal in Column L for the values in Column K that all have the same date in Column A. All of the Dates in Column A are in chronological order. No dates are out of order. Example A1 = 11/2/2008 : K1 = 22.00 A2 = 11/2/2008 : K2 = 25.00 A3 = 11/4/2008 : K3 = 12.50 A4 =...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...