Search results

  1. B

    Help needed in Custom AutoFilter

    Hello, I have a list of warehouse bins that range from 099A to 15000F. When I use the Custom AutoFilter to only show bins that are in the 2000A range, I use “equals 20??A” Problem is, there are locations that are named 200AA, 200BA, and 200CA. I need a way to filter the double letter bins out...
  2. B

    Overtime Formula

    Hello, I need urgent help on this matter. The formula in L works correctly and up to a point, except when the hours change between Shift Length D8 to 10:00, and in Hours Worked G8 shows 11:00, but in Scheduled overtime L8 it shows 01:12 instead of 02:12 =MAX(0, IF(D3>=TIME(10,0,0)...
  3. B

    Need To Return The Same Value Across Multiple Cells Based On Multiple Criteria

    Hello, Hopefully someone is able to help me please, I'm trying to add a formula that it returns the same value across multiple cells so the goal is to add an appointment status (column E) based on multiple look ups but only return the same value rather then show results from each row, so, if...
  4. B

    Ignoring Null Cells In The Sort Function

    Hello, I'm currently working on a file for cataloguing data on clients. One of my columns contains a formula that spits out -null- spaces under some conditions (on purpose) and now i'm encountering the issue, that when using the sort function, these cells appear on top, hurting the...
  5. B

    Week/Supervisor Wise Attendance

    Please, help me with the Excel formula to get the week-wise supervisor-level count of attendance and leave in the yellow highlighted cells. Attached is the Excel file with the sample raw data.
  6. B

    Conditional Formatting Or Macros And VBA Coding

    Have spreadsheet were columns D thru I. Column G is tested to determine what color the letters will in columns D thru I. Certain rows that are totals will be skipped. Should I be using Conditional Formatting or Macros and VBA Coding. ??. I have a total of 11 groups of Columns D thru I. Thanks...
  7. B

    Send Email When Excel File Gets Unprotected

    Hello Everyone, Is there any way to send an email by vb script when Excel file gets unprotected? If there is, can you provide me the code as well? I need this for one of my review courses. Thanks in advance for your suggestions. Best Regards.
  8. B

    Tool

    Thank you for any help/guidance you can provide.
  9. B

    Hello Everyone!

    My name is Dan H Bowen. I am an adjunct instructor at South Gate Creative Writing School, Aalborg.
Top Bottom