tickets

  1. S

    Ticket Prices: Date Ranges

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

    Extracting text from a random string and matching to a list

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

    Matrix Table - Add Column to the end of the Matrix (not on every column)

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

    Conditional Formatting in VBA with an Expression

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

    Delete a specific text in Raw Data

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

    Formula for total price less bulk discount

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

    Help with simple pivot table

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

    Target.Value <> OriginalValue

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

    Generating a Random Number Table, where all of the numbers within the table are not used

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

    Excel list with range of values

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

    Macro to automatically add macro-enabled buttons to a row as new rows are added from a linked Sharepoint list

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

    Formaula Assistance

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

    Ranking formula

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

    % of 2 cells in a pivot table

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

    Formula or vba code to calculate the values between two numbers with criteria

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

    Tracking Ticket Sales & Assigning Ticket #s

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

    VBA create emails based on content

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

    lookup and validation

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

    vlookup returning same value

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

    How to number sequential items and put number all numbers into a cell with a delimeter

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top