resolved

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

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

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

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

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

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

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.

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

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

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

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

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

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

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)...

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

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

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

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