fun

  1. E

    Workout Randomizer

    Hi all, I am trying to make a randomizer in Excel to randomize my workouts. I currently have 4 workout lists in Excel: Abs, Arms, Chest, and Legs. The lists are made of strings with no numbers. What I want to do, is to have 3 different buttons, each for a different day (Arm, Chest, and Leg)...
  2. T

    Couple of things

    Hi, this is abit complicated to explain what i have in mind here, so pictures where needed im sorry if i broke the rules here and im sorry if you cant understand what im trying to do here, its kinda hard for me to work out myself, but im looking just to make this some what easier for me maybe...
  3. R

    Excel Fun - Slot machine Style Result

    Hello all, For a bit of fun in Excel I have an If argument with 2 possible outcomes where I'd like the result to appear to spin (slot machine style) in the cell before settling on the result. Is this possible? Many Thanks
  4. S

    Detecting Duplicate Pairs

    Please help!! I have a large list ofcompanies (approx. 180,000 rows) that placed bids on different contracts. I amtrying to determine how to figure out how many TOTAL times each company bidagainst one another. Any suggestions?? Sample dataset is below: Contract Number (Column A)...
  5. R

    Fun one - I have a user form that opens with an image embedded, I want a different image to show approx. 1% of the time.

    Just to give the staff using it a nice surprise.... Thinking I could use "Randbetween" 1-100 and say if it's 1 then show image A, if it's 2 then show image B, if not then show image C. Image C would therefore be the default with 98% chance of showing, where image A and B have a 1% chance...
  6. E

    Rank by Person, without Repeats across people

    I have a set of data that is salespeople (column A), and how much they sold (column C) by client (Column B). I need to get the top 5 clients by sales for each salesperson; however, no duplicates across salespeople. So if John Wilkes had $10M to Fun Company as his #1 , and Jane Bridges had $8M to...
  7. D

    VLOOKUP, MATCH, Not sure which

    i All, Have come to a wall I'd love to de-brick...Not sure which function or how to solve this problem. I've a single sheet that contains the following... <colgroup><col style="mso-width-source:userset;mso-width-alt:3776;width:106pt" width="142"> <col...
  8. F

    Count total rows in multiple columns with input values from list

    Hello, I'm struggling to determine how to count the total number of rows (from a range of 2 columns) that contain entries from a list of strings. <tbody> Row Col A Col B Col C String1 String2 String3 1 Fun No Fun Yes Odd Fun Confused 2 Fun Fun Yes 3...
  9. V

    Calculation that includes DATEDIF with division

    Hello Lovely Forum Peeps! I'm working on a 'Daily Funds In' Chart and generating fun accounting numbers based off of the daily funds in. (ACCOUNTING IS ALWAYS SO MUCH FUN!! JK, I know I only think so :-P) My chart consists of a cell for each day laid out as the week (Sunday - Saturday) and I...
  10. M

    Forecasting FUN

    Hi, ok so I have created a forecasting workbook which takes (I work in a hotel) our rooms occupied divided by the actual guests we got for breakfast, lunch and dinner and gives me a percentage (we call that capture ratio). I break down these and average them throughout the month by the day of...
  11. S

    VBA - Checking if active cell is named, then....

    Hi All, I'm trying to write a macro to insert new rows once the final row has been reached. I've named that cell "FinalLine" and have compiled the relevant bit of code below. The code works if the Active cell is the last "FinalLine" cell, but breaks when the active cell is not "FinalLine"...
  12. M

    Name Manager Fun in Excel 2010

    Hey guys, I've had a hunt around and I know there are some really good Name Manager solutions, but my one is a little bit strange. I have a lot of duplicate names in the Name Manager. This was from a rebuild when some LiveOffice components stopped working. When I delete the Name Manager...
  13. K

    Ant Colony Simulator

    Many months ago I posted a file as part of a question I had, and have noticed I still get people opening it here months later, so thought I would post the latest (as of 3 months ago :stickouttounge:) version (much changed/improved over anything posted before) It started as a self-refresher...
  14. N

    Just for FUN Easy Login with Macro

    When i get to work I need to login to about five different programs! sometimes taking an exorbitant amount of time, sometimes as much as ten minutes! I want to be able to click one shortcut on my desktop and open and login to most of my programs. I have done this with most of the programs I use...

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