ticket

Hi, I’m stumped and need help. I have a file with thousands of entries and I’m trying to add 3 columns that count the first instance of a word in that specific range. It will check for “notable”, “minor”, “test”. Column B will have ticket numbers (many of them are duplicates ticket numbers but...

Hi, In column B I have ticket numbers and there are 12 instances of each ticket (may grow). In column D I have clients. In column E I have specific text (e.g., alert, no alert, etc). In column AM I need it to show 1 or 0. I want it to only count the first instance of colum B (ticket number) and...

Hi, I have a text field that is filled with updates for each time someone goes into the Ticket Tool to update a Ticket. When exporting the data it comes through all in one cell for that record. Is there a formula or VB that can search the cell contents, look at the date and count the number of...

So essentially i have two workbooks. One looks something like this: <colgroup><col><col><col><col></colgroup><tbody> Username First name Last name Ticket number User1 Jim Bob User2 Bob Jimmy </tbody> And the other is very similar bar a few extra columns. I need to be able to pull the...

I have code that pulls from a database and inputs into an excel sheet (shown below). Selectstring = "SELECT " & c.Item("Ticket1") & _ ", " & c.Item("Description") fromString = "FROM " & ibmLib1 & "." & t.Item("NCType") & " " & t.Item("NCType") & _ "...

I'm trying to get my head around how to find a situation where I might have a field where two tables match, but, where another field might not. I'll try and explain this the best I can. Table 1: <tbody> Lease ID Ticket Number 22045 100542 22046 100543 22047 100544 22048 100545...

I have a data sheet where each line shows an employee's name, type of work order created, date/time created, the ticket number, and the day of the week. I have a column chart (made from a pivot table) which displays one column for each type of ticket (with the number/value displayed at the top...

First let me say that I get a little better with Excel almost daily by searching this board. The people on here are fantastic and all the help is greatly appreciated. I ran into a unique problem that to me is just mind boggling a small problem I can't fix regardless of the what I do but it...

Dear Expert, Can you help me find a formula that will solve my problem. <tbody> Ticket Sequence Validation Code Amount Date Name 1234 8814 5000 Apri1 John 1222 1598 100 May2 Mark 1221 2456 150 Feb4 Luke 1234 6871 200 Mar10 Matthew </tbody> Can your give me a formula that will...

I have a spreadsheet that has something similar to thefollowing:<o:p></o:p> <tbody> <o:p></o:p> Find this number in range A1:B4<o:p></o:p> Bring back Officer who issued Ticket (ticket assigned to)<o:p></o:p> A<o:p></o:p> B<o:p></o:p> C<o:p></o:p> D<o:p></o:p>...

Good Day, This formula works for adding a ticket for every full 1000 =IF(A1<=1000,INT(A1/100),10+INT((A1-1000)/1000)) Is it possible to change above formula base on below rules? Many Thanks Every 100= 1point Between 100 to 1.000= 10point Every 1,000= 1point Between 1.000 to 10.000= 10point...

Hey all, I deal with a lot of ticket rolls in my industry and was wondering if there's a way to simplify counting the number of tickets used for a venue. On sheet 1 i'd like to have column a be a starting value of ticket #, column b the number of tickets in the roll (i.e. 1000 or 20000) and...

I have a description coming in from my vendors that not consist. Sometimes I get TKT or Ticket in a cell. No sure which function to use. If c3 contains TKT or Ticket. Then return TKT in d3. Thanks in advance Kevin

Hi, So I am wanting to help make some of our team's work a little easier but have no idea how to go about it. We have this spreadsheet that is filled in with information needed by various teams to create accounts. These teams fill in the information manually from a ticket that gets...

Hi, Am hoping that you guys can help. I am looking for a formula that shows if cell c8= Smart and cell j8 time is less than 4:00:00 them put Met SLA but if j8 is over 4:00:00 put Failed SLA and if C8= Customer raised ticket or Public raised ticket and j8 is uner 0:30:00 put Met SLA and if J8...

Hello- I have data that is in 2 columns where the Ticket # is in column A and the data from the ticket is in column B. I am trying to write a macro that converts the data to 1 row per request. The caveat is that 1 ticket can have up to 10 requests within it (number of requests vary per ticket)...

It seems I can't find a straight answer anywhere, so I hope someone here is able to answer my question, or at least guide me in the right direction. I'd like to know if there's a way to import specific data from an online source, such as a json or xml file, have it automatically populate the...

Hi I have a ticket resolution data as shown below. I would need this data to monitor my SLA compliance. Excel 2007 32 bit <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>#F0E0E0[/URL] "] A B C D E F </thead><tbody> 2 Ticket Assigned Date Acknowledged...

<colgroup><col><col></colgroup><tbody> POINTS TICKETS 7,030 17 6,711 16 4,709 14 3,651 13 2,990 12 2,970 12 2,580 12 800 8 300 3 </tbody> Good Day, I would like to ask you in regards the given table above which I like to get the result when it comes to calculate promo...

Hello, I was wondering if there is a formula on excel to do what I am trying to do: Example: Lets say John and Lisa was entered into a draw, John has 10 tickets and Lisa has 5. <tbody> Name Ticket Entries Number John 10 1-10 Lisa 5 11-15 </tbody> So my excel would look like this except...