tickets

I am trying to calculate how much someone needs to pay me, where the ticket prices are set for a certain period. I have already have help to get this far, but I'm struggling to work out why the formula would work in Office365 and not Office 2013 In Cell F2...

I have a csv file which I have downloaded to Excel. The name of this worksheet is 'Tickets'. This contains text strings of random length which include standard 'labels' of random length. The text is in column C. The phrases in the text are separated by "|" which may assist. I have a separate...

Hey Guys, Looking for some help here - I havent been able to find a solution anywhere. I have a matrix table that provides a view of aging inventory. For each client they have a number of days to work the ticket before it is outside of SLA. I want to add a column that shows when those...

Good morning, everyone. I have a static cell ($A$6) on worksheet that is the goal for the number of tickets that should worked on during the week. Starting at cell (C11), I have a range labeled "rg" that is Dynamic and could span many columns depending on how many teams submitted tickets...

I have a set of raw data I export everyday. When I export the data, all the raw data is on 1 column. I have a row that says "2 tickets" and need to delete the "ticket" and "tickets" text before I can add to my access database. I only want the numbers to be intact. I do not care of the...

Hi: I have been struggling for a solution and I need some help. Expected values are in column H to J In H2, I am looking for a formula for total cash due: = look up value in A2, return ticket price x tickets sold, less cash discount (per discount band) x ticket sold Excel...

Hi All, I have two columns of dates. One is support tickets opened one is support tickets closed. Each date entry on a new row represents a ticket. When I try to put a pivot chart together the opened and closed per month figure is coming out the same which it shouldn't be. What I would like...

In my code below I was expecting the data to be saved to the storage file only when a item in column b was changed a different value. However, even when you change (for example) Tickets to Tickets it adds these changes to the log file. What am I missing? Private Sub Worksheet_Change(ByVal...

I received some help on this Forum last October from Rick Rothstein creating a Random Number generator table, assuming 500 numbers (1 - 500). This Table is being used for a Reverse Raffle at a Charity Function in Ohio. To execute the macro, I am prompted to enter the first number in the Table...

I'm working on a spreadsheet where a user enters ticket numbers for a raffle for a given customer. My data is currently in this format: <tbody> Customer Ticket Issue Begin Ticket Issue End # of Tickets Total Sale customer 1 '001 '002 2 $40 (2 tickets @ $20 a piece) customer 2...

Hi everyone! I've often perused this forum for the wisdom that exists here, and am finally reaching out for some specific help. First some background: I'm building an Excel "tool" that is meant to track the status/progress of a "ticket." There is a SharePoint tool where new tickets are...

I own a small business and I'm having trouble with employees adding incorrectly and I'm wanting to create a spreadsheet that will do the math for them. As a part of my business I sell lottery scratch off tickets. Each ticket is numbered and we count them down at the end of the day to determine...

Hello, I am trying to rank the employees based on the percentage of return ticket sales. But only if they sold more than 2000 tickets. I am unable to work out the formula for this. Can someone her help me on this? Here is the sample table and Rank is the desired answer...

I'm doing a pivot table. There are rows for each person on my team. Column B is "Total Tickets", Column C is number of those tickets per person that are closed - field name is "Status". I need column D to show each person's % of closed tickets. I can manually enter =C10/B10, etc but I want...

<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 want to create a spreadsheet for a video game 50/50 drawing that I am in charge of weekly. And I need an easier way to assign the ticket numbers. So basically tickets are 2K per ticket. But if you buy 5 tickets, you get 1 free. I want a spreadsheet that has three columns: Name...

I run a macro that returns a table similar to below. These are change control tickets that need to be approved by 4 managers (APPDev, Help Desk, etc). From this table I would like to run a macro sending a single email to each manager listing the specific ticket number(s) that need to be...

Hi everyone, i have a problem, that makes me spend hours sorting but i am sure there is a way that can be done in seconds, it starts like this i receive a monthly report and the below two columns are in it, i need to validate all ticket numbers if they are available in the database or lets...

So I am trying to do a vlookup stating if tickets are under 30 days old, 30-59 days, 60-89 days, over 90 days old. Due to the source of where we have to pull data from I have had to create a "Days Aged" formula to base this off of =DAYS360(C9,C10) (Column C is my Date created). All my my...

Please help me write a vba that can create the data in the second column. Any help will be appreciated. There will be a large amount of tickets, and each individual may purchase as many tickets as they like... probably no more than a few hounded. <tbody> # of tickets ticket # 4 1,2;3;4 3...