raffle

  1. C

    IF

    Could someone please confirm best formula for MINIMUM CHARGE - £ 5,000 IF A RAFFLE DOESN'T REACH £ 5,000 THEN THE AMOUNT COLLECTED ROLLS OVER I.E. RAFFLE - £ 2000 FORMULA CALCULATES THAT £ 3000 ROLLS OVER Also I have a formula tab with workings and styles i.e. cell sizes but when I copy...
  2. E

    Performing two functions with one click, rand() and sort

    Hello Everyone, First time poster! I am conducting a raffle at work. I have a list of 100 people and a number associated with each one. The number next to their name will correlate to a number in a raffle basket. There will be multiple raffles and each raffle the numbers need to be randomized...
  3. F

    Raffle Number Values (300+) live and linked in AutoFormat/Smartart. I need suggestions.

    First post, used this site in the shadows throughout my career. The local alumni association use old, physical, heavy boards to display numbers 1-300 for a reverse raffle; last number pulled wins pot, prizes along the way. I currently have a neat workbook, I need to have numbers still playing...
  4. C

    random unique numbers/ names put into a grid - help needed

    I am doing a cow patty drop for my local non-profit community group. We are selling tickets (numbered 101-676) for the event. In order to show who's name ends up where in the tennis court that will be marked in a 24 x 24 grid, I would like to show each ticket number (or preferably the...
  5. S

    Excel automated raffle draw

    Hi all, I know how to randomly select a name from a list in excel but what I would like to do is be able to click a start button in excel that generates a 5-10 second message before announcing the winner i.e Are you ready........and the winner of the Ipod is...........randomly generated name...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top