min

is it possible to input 1 and 2 only in textbox ?

Hello, I need a simple MIN formula with 2 criteria. Below Is the table <tbody> component description qty a systematic 10 d non-systematic 62 c systematic 84 b systematic 56 d systematic 3 b non-systematic 1 a non-systematic 9 c systematic 84 b...

I want to start off with saying that I have scoured the internet to find this answer -- it's driving me crazy. Someone please help!! I need an excel formula that calculates a date based on: 1) Minimum age of 58 years 2) Age plus service is 70 or greater

Is there a way to combine these 3 formulas? =MAX(DATE(T2,1,1),DATE(T2,1,1)-WEEKDAY(DATE(T2,1,1),2)+(S2-1)*7+1) =MIN(DATE(T2+1,1,0),DATE(T2,1,1)-WEEKDAY(DATE(T2,1,1),2)+(S2*7)) =CONCATENATE(TEXT(U2,"[$-409]D-MMM;@")," to ",(TEXT(V2,"[$-409]d-mmm;@"))) (T2 is the year and S2 is the week number)...

Hi, I have a pivot table with the left column numbers 1-100 And I want to be able to filter between 2 numbers (from user inputboxs for min and max) Eg. Numbers 11-20 or 1-80 Unsure how to do this, Any help appreciated

Hi All, I am working on dashboard in which target based scores are being given. e.g Min & Max target for Calling - Minimum 60 call and Max >=70 calls per day Minimum score 0 and Maximum is 20%, Score will be proportionate where Achievement 61= Score will be 2% , Achv 62= Score 4% and so on...

Hi, I'm looking for a simple formula that will calculate the difference between a start and an end time then subtract 30 min. So, for example, the start time is 7:00 am and the end time is 4:00pm. I can calculate the time difference but I don't know how to then modify the formula to subtract...

E F G H I Company A Comp B Comp C $1.00 $.30 $.24 =min(E2:G2) Comp C $.53 $.62 $.51 $.40 $0.00 $.46 The simple MIN...

I have the range below and would like to find the MIN to a range of cells for the MOD of the value. In H9 I'm looking for the MAX, but in H10 I would like the MIN. Here is the formula I'm using for the MAX. Is this the best method to use? Cells H6 and H7 are actually 0.00. I just have the...

I am trying to figure out if there is a way to use conditional formatting with data validation list like this. 1st I have a list from data validation of performing a task. I will use 4 task that I do once a week. Mow grass, wash dishes, wash car, clean pool I want to set a time for each, and...

Below is a sample of the data set (starting in cell A1) I am working with (the real set has many more rows & columns). I have a formula which will return me the Min value (-2.2) and the Max value (3.0). What I am trying to do is add a formula that will return me the location of where the Min...

Hi All, Looking for min Max formula which will return following answer If A1 =<.4% Result (in B1) will be 0% & if A1=>.2% Result will be 5%. Please help me build this formula. Thanks & Regards, Sanket 7738414678

I'm unsure what formula I need to return an adjacent value to the min value from a set of columns... My excel knowledge is very limited I have data in cells BC20 to CJ20 and down to BC136 and over to CJ136 I have numbers in every other column and text in between example: BC20 has pricing...

I have two named Tables detailing price proposals from mfrs on different dates I want to merge these into a single table detailing the minimum cost and associated detail per Item <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Item Mfr MPN Cost 10001...

Hi There, I'm working on my budget spreadsheet, i have a column of numbers generated by our budget formula. I want to add a formula in the next column that will adjust those number to a maximum of $35,000 a minimum of $10,000 and round up everything else to the nearest $100. It is possible to...

Hello, I use this formula to get the actual charge (AF19), Min Charge (AG19), Or max charge (AH19) by days of the month. Question is how do I keep the cell for say the June 2nd total blank without the min charge populating if the data is not filled in yet in the other cells to get the total...

I have a multi-tab spreadsheet that I want to extract the MIN and MAX values from the monthly tabs and transfer them to my "FL" tab. The code I use now does not allow for me to just drag the top value down to fill in all the cells in the columns. I think that "INDIRECT" might be what I'm looking...

I'm revisiting my file and wondered if it's possible to tweak and to apply a minimum and maximum date. Basically, this is my data <tbody> PARTNO1 Hyundai Accent 01/01/94 31/12/99 PARTNO1 Hyundai i30 01/01/98 31/12/16 PARTNO1 Hyundai i40 01/01/99 31/12/17 PARTNO2 Hyundai Accent...

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