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 with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top