min value

1. Min Value with Formula?

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...
2. How to Get Min Value of three months

I have data of few months. <colgroup><col><col span="2"></colgroup><tbody> Date Name Value 01-04-2018 a 2 03-04-2018 b 2 05-04-2018 c 8 07-04-2018 d 3 09-04-2018 e 1 11-04-2018 f 3 13-04-2018 g 10 15-04-2018 h 9 17-04-2018 i 5 19-04-2018 j 7 21-04-2018 k 4 23-04-2018 l 5...
3. Finding min/max value from a list of items that contain duplicates

Hello everyone, I tried searching for a solution to this, but couldn't find exactly what I was looking for, so here I am. I have a list of thousands of items (with many duplicates) from different vendors and I need to be able to quickly pull the lowest cost of each item with the associated...
4. logarithmic graphing

BLUF: Are the logarithmic basis (not the base) and the min value independent variables when graphing logarithmically in Excel? Details: I would like to graph vibration amplitudes, which are displayed logarithmically on both the x and y axes. I know how to change the axes to display...
5. Iteratively Get Array Position Index and Update Array Value

Hi I am trying to create a program in VBA where I have an Array A and I am trying to Iteratevely find the minimum value in the array, get its position in the array and next update its value to an arbitrary large number (say 9999). The code I have come up with so far is something like this For...
6. i want required vba Code. I am looking for a small value from the Range

Value Range Requirement 25.000 1750.000 17.000 17.000 1750.000 17.000 33.000 1750.000 17.000 18.000 1750.000 17.000 33.000 1750.000 17.000 47.000 1750.000 17.000 66.000 1750.000 17.000 21.000 1750.000 17.000 41.000 1750.000...

This Week's Hot Topics

• Use Filter function with 2 criteria to return a specific value
I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
• Loop stopping at row 10
Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
• Numerical Order Code for Macro
I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
• Calculate time in excel
I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
• VBA
Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
• Help with formula to sum numbers prior to date
Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

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.

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

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