1. J

    Max unless blank

    I would like to calculate the Maximum date resolved from a column of resolved dates, unless there are blanks in the resolved dates column. If there are blank cells in the column, I would like the result to come back as blank. The intent is to highlight whether there are outstanding service...
  2. V

    Counting through a large table

    Hi I have a project with about 240,000 rows of data and 23 columns. There are two columns that I need to compare dates to that are; Date Logged and Date Resolved. The date I compare them to are usually the first of each month from 2017 to present day. I need to track whether or not that case was...
  3. R

    Excel help please.

    I'm having a hard time figuring out what i need. I have two sheets one with Raw data, then Results On results page i have name column then resolved and then Open. I want to have the results look at the name column and search on the Raw data sheet on column G the name column and count how many it...
  4. H

    Multiple Duplicates and Pick up Key Work Formula

    Hello All, Need some assistance. I have a spreadsheet with duplicate numbers (3 rows). Each row for that duplicate # has a phrase such in Column Code as Hardware, Removed, Resolved. If I have duplicates how do create a formula to pick up the word "Resolved" for the duplicates? Thanks in...
  5. C

    Concatenate Moving Range

    Hi there! Been a long time lurker of the forum, but finally forced to ask for help on something I have a column with values e.g. in B1 I have "red", B2 has "Blue", B3 has "Green" etc. In another cell I have a randbetween function e.g. C1 = randbetween(1,N) I want to concatenate from cell...
  6. K

    No Option to MARK issues as RESOLVED

    Greetings, First off, great work that you do! Really a benefit to the community! Question: Would it be possible to include a column in your forums and an option within threads that shows if the issue was resolved? Something where users could mark issues as resolved once they receive an...
  7. L

    match() and duplicated values

    Hi I learnt how to use match() function. I have in a column 2 cells with the same value. When I tried to use match(), it returned to me the row of the first value. How that can be resolved? Thank you.
  8. M

    More Than 24 hours and Less Than 24 Hours

    Hi All, I have below tables which shows Query received time and Query resolved time. Now i need a formula in Column C to show, if the query is resolved with 24 hours or after 24 hours. Can someone please help <colgroup><col span="2"><col></colgroup><tbody> Query Received Resolved Duration...
  9. P

    Macro in Personal Workbook

    Hi - I am new to macro's and recently recorded one but when I ask a colleague to run they tell me that its in my Personal Workbook and they cant run it Is this something that can be resolved please in Excel 2010
  10. S

    Count number of cells after a time range in one column and before a time range in another column

    Hi, I have two columns in the format d/mm/yy hh:mm - e.g. 8/05/17 16:00. One column - A - is the expiry time of a ticket while the other column - B - is the transaction time of the ticket. Given a time I enter into C1 (same format as above), I want to count the amount of transactions that...
  11. P

    Workbook events not working but Application.EnableEvents = True!!!

    Hi I've got a major issue on a machine where none of the ThisWorkbook or worksheet events are triggering such as Workbook_SheetBeforeDoubleClick are working. I have checked the setting for Application.EnableEvents and that is definitely true. I think an Excel dll or setting something is...
  12. K

    VBA concatenate all cells that meet a condition (vlookup value)

    Hi, Imagine I have names of employees in column A and the name of the line they are working on (line 1, 2 or 3) in column B. What I try to have in C1 where the value is Line 1 is a comment with the name of all employees working on line 1 that day. My issue is that I can have from 1 to 40...
  13. K

    VBA how to avoid target looping?

    Hi, I have the targets that run my macros spread on 3 column (A,B,C let's say). My problem is that if you select a specific value (Product 123 for example) in A, B, or C (let's say B in this example) I need to put product 123 in A & C: a message pops up to ask if user wants this, if he says...
  14. K

    Run macro when click on cell rather than value change

    Hi, I have a pretty long macro running when changes are made to a group of dropdown menu (if the user change value, put the same or delete the value), using <tbody> Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells as Range Set KeyCells = Range(Whatever)...
  15. K

    Using referenced names by formula

    Hi, I was wondering if there was a way to "build" referenced names in formula. As an example: I define A1:C3 as "Line1" and I have in B4 the word "Line" and C4 the number "1" -> instead of vlookup(K1,Line1,2,false) to have someting like vlookup(K1,function(B4&C4),2,false) Thank you...
  16. K

    Stop (target) Macro From Prompting To Debug

    Hi, I have a a target macro that starts with Private Sub Worksheet_Change(ByVal Target As Range) Dim Keycells as Range Set KeyCells = Range("R:R,AF:AF,AT:AT,BH:BH,BV:BV,CJ:CJ,CX:CX,DL:DL") If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is Nothing...
  17. B

    List Of Files as per the Date created

    Dear All, I have a user form with a listbox. On userform initialize event, I have a code that display all the .mdb file in the listbox. But the problem is the items are sorted alphabetically by the month name. Is that possible to list the file as per the date created from the latest to the...
  18. J

    Using If Else to return vlaue other than 0 when an inputbox is canceled

    Hi, I have an inputbox that sets a public variable and uses if...else to change that value if one has already been set. What I'd like to do is when the user runs the sub when a value has already been set and clicks cancel rather than entering a new value, the value stays as it is rather than...

Some videos you may like

This Week's Hot Topics