ticket

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

Hi all. I have an interesting task that I do not know the solution for. I have a range of data from C72:C101 that contains expenses. The data only goes on this sheet because the data comes from somewhere else, so it is copy and pasted into this sheet and there are formulas on another sheet that...

Hello! I wonder if someone could help me? I'm trying to combine multiple rows into a single row. My data currently is formatted: E-mail,First Name,Last Name,Event,Ticket Name,Spaces email1,John,Taylor,C,81,5 email2,Mary,Smith,A,81,2 email2,Mary,Smith,D,144,1 email2,Mary,Smith,I,81,1...

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

Hi Experts, I want a excel formula which picks only number from text. I have a column contains only numbers (456) and numbers and text (NUM 123), but I wanted only nubmers in the another cell. Please suggest. Tickets NUM 123...

Greetings, I have yet to come across anything quite like this and I will try to be as thorough as possible... I have been given a sheet of raw data that spans 6 months of time, consisting of 11 columns and 4000+ rows. I am focused on 4 very specific columns: "Ticket Priority" "Ticket...

Hi , I am in the midst of fundraising for a Gala Day and I need to creat tickets for a bingo tea. I want serial numbers on them to avoid counterfieting. (Yes, it is that type of place) I am looking to have the serial number in Column E Due to the text the Rows are likely to be 4,8 , 16 etc...