min

Dear Excel community Goal I'd like to write a VBA macro using Solver. I've no previous experience with macros. I am looking for a dummy guide please. Solver input Set Objective: 'Calc optimised'!$J$14 To: Min By changing variable cells: 'Calc optimised'!$E$3 Subject to the constraints...

I would like help with the following ... Let's say events occur regularly, say every 90 minutes, starting at midnight. Given two timestamps, I want to calculate how many times the event occurred from time 1 to time 2. Some examples: 00:05 - 01:25 (1 hr 20 min): The event did not occur at all...

Trying to capture time, elapsed time, duration however you want to look at it. I want to be able to enter it to the nearest 1/4hr 4 hrs 00 min 4 hrs 15 min 4 hrs 30 min 4 hrs 45 min I'm not able to get this to work correctly.

Good morning/afternnon/evening I am managing a team of 30+ agents, based on different schedules, some have 1 hour lunch, and another some have 30 min, the number of agents is changing ( 15-35 ). So I need to find a way to conditional format when a 30 min agent takes more than 30 min an color...

My data set has a list of people with an assignment date. Each person can have multiple assignment dates. I need to find the earliest assignment date for each person. I am trying to solve this by first doing an index match array formula to identify all the assignment dates and then applying a...

Racking my brain on this one... creating a table of 1-10 buckets to show the average of values that fall in those buckets. The buckets are simply a min as the lowest, max as the highest, and the rest is equally distributed between the min and max. The issue is that when I also do a count of...

I use formula to display 3 hours 7 mins as 3,7. However formula does not work correctly as it should be 3,07 also the are problems with , and . depending on Excel version. I don't need it to be 3,07 or 3,7. I need formula to round it to either 3,5 or 4. So if it is 3,07 then it should be 3,5...

I have a couple userforms with very similar code, see below for an example. The problem with them is occasionally excel freezes as they are opened right before the form is displayed. Pressing ctrl-alt-del and close excel pops up with a cannot close excel waiting for response/input from you...

I have an Excel sheet running on a big screen and would like to refresh the sheet every 1 min or so. The code below I can refresh manually but can I run a second macro or add to this on and refresh and save automatically? Thanks Sub Update() ' ActiveWorkbook.UpdateLink...

I'm stuck, i'm working on a macro which should consolidate some data. See this printscreen. The macro should produce one line for each date with an average, min and max of temperature and humidity. This is as far as I have come, I manage to print a dictionary with the data, but I don't know...

I am conducting a bid. I have 5 items I want to purchase at varying quantities and am receiving bids from 4 different vendors. I know how to calculate total min spend and show which vendor to utilize for each item. Say I want to only set up purchase agreements with only 2 vendors. How can I...

I'm looking for assistance on an Offset/Indirect formula I am using MIN Formula is =OFFSET(INDIRECT(B8),0,1,1,1) MAX Formula is=OFFSET(INDIRECT(B8),0,2,1,1) Good news is that those formulas pull from the correct Named Cell Areas Bad news is that the Offset hard wires the Min Max Cells as the...

Hello Everyone, You guys always blow me away with your solutions when I've needed them. Thank you! I have a formula, =Round((AW2*.85)+IF(V2="yes",-700),-2) and it works perfectly but I would like to add a min value of 4000. I have tried =MIN(4000,.....my formula, but not been able to get...

Good afternoon, I am trying to apply a tax bracket in my model, and wanted to use a simple formula to calculate my tax expense, I have a table displayed as follows <tbody> A B C 1 CIT rate Maximum Profit Profit 2 0 3 22.5% 1,500 36,500 4 25.5% 7,500 5 27.5% 35,000 6 31.5%...

Hi, I have a work book with two sheets. On the Sheet1 I have a table with data for Restaurant in cells A1 to I4 Then I have data for Super market in cells A6 to I9 Finally I have data for Coffee shop in cells A11 to I14 <tbody> A B C D E F G H I 1 Restaurant Discount offer...

HI GUYS, I am trying to get the min and max date for a customer from the data below <tbody> Name item qty start date end date Alan S 3 <tbody> 01/09/2013 </tbody> 31/12/2014 Alan S 5 01/11/2015 31/12/2016 Alan S 2 <tbody> 01/01/2016 </tbody> 31/12/2017 </tbody> i want...

Hello and thanks in advance for any help. I'm trying to create a purchase sheet that includes a set up fee. The fee is either a percentage of the total or a flat fee of $130 whichever is greater. I have the formula calculating the percentage based on the subtotal [=15% * C1] but I want to...

Hi. I've googled a lot, tried alot, but cant get it to work, so i'll ask here. Im looking for a simple way to make a countdown timer in a label. I want it so when the userform loads, a coundown timer from 5 min shows in a label, counting down, in min and sec. Does anyone know how to do this?

Hi Someone who can help me figure out the product sum for min, max and the colored cells in A2:C9. The coloured cells have a colour index of 15 and 40. Preferably VBA code /Bilbon <colgroup><col span="3"><col><col><col></colgroup><tbody></tbody> <colgroup><col...

I'm making a grocery list in Excel. One sheet has my list then next sheet has a listing of my local grocery stores with items, prices and weight. I want to search thru the items against what's in my grocery list for the lowest price. I only have Microsoft Excel 2010. I'm trying to use MIN and...