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