minimum

Hi, I have a table with ID numbers that repeat in some sections, in each of them, it will have a different K value. There is 3 possibilities, 0 indicates INPUT (IN), the maximum value is LATERAL OUTPUT (OUT L) and the middle one is DIRECT OUTPUT (OUT D). How can i do this?

i have 2 column from which i have arrived minimum value of 2 column like that i have around 65000 thousands row from which i want to highlighted the cell column from which minimum condition has arrived and if the value of both the column is similar then the first column should get highlighted...

Hi MVPs and Gurus, I would like to ask a favor if you could direct me on the right path as I am a bit stuck. I'd like to write a macro to find maximum and minimum in specific columns of sheet1 and return the value to corresponding textboxes on a userform. For example I had a userform with a...

Hi there, I'm attempting to return the minimum value from a range I've selected but I'm unsure how I can select the minimum value in the range (only) where the cells (in the range) are formatted thus: £#,##0.00;[Red]-£#,##0.00 The VBA code I've used is as follows to get the MIN value and...

Hello I'm looking to figure out the best way to figure out a rate with multiple criteria. If Cell 56 is not 7 or 15 I need to take the rate (Cell F56) - subsidy (C91) and select the minimum of that against rate (Cell C61). So whichever is the smallest should be selected. Then the minimum needs...

Newbie on the forum. I have set up a nice spreadsheet to where I can see who has won the hole by using conditional formatting to highlight the cells equal to minimum value, which is located in row 45. I have two questions... 1. How do I UNHIGHLIGHT the cells if there are duplicate lowest...

Hi. I have a question regarding how to find the median, mode, maximum, minimum & maximum with multiple criteria. I understand that I have to use the if function, but I am not sure how to go about it. I attempted to find the median, but I got an error (#value!). Here is the formula that I...

I get tables of Unit Type (# of Bedrooms), Prices, and SquareFootage ranges regularly. I need to condense this information into a table that shows units of the same time, with a minimum to maximum of price, and a minimum to maximum of SquareFeet. I've been sorting the columns for unit type...

Hello, Is there a possibility to use the aggregate function such as the below and ignore a certain values (in my case 0) of the range investigated? =Aggregate(5,4,range) Thank you in advance. Shiro

In Column A, I have team function, in Column H I have Status, in Column S, I have Weeks Active. I need to return the minimum and maximum values in S (not including 0) if A = "Chief Operating Office" AND H = "Active" Does anyone know how to get this going? I'm dying inside trying to figure it...

I have two Array Input(k) and Output(k). I am looking to print Input(k) value for the corresponding minimum Output(k). This code is giving p = 1 but my minimum value is not at the index one in the array. p = Application.Match(Application.Min(Output), Output, 0) Debug.Print p Set rDest =...

Hello guys, I have found the answer of a bunch of my questions through communicating in this website and hope this time be the same. PROBLEM: take some parameters (i) each with a minimum and maximum capacity. I have an amount of entry which can be assigned to each parameter so that at least...

Hello, I'm still conducting my own search of trying to find the answer to this, but in the meantime thought I'd do a post to see if anyone has a ready answer. Difficulty in conducting the search is the multiple conditions. Basically, I need to search an array for a specific string and then...

Hello guys, question regarding averages: I am looking for a way to average the time in the columns with hours and that for each column. It may only select the lowest value of the lines with duplicates (since this time stamp is relevant). Any ideas? Been trying with averageifs, min, ... but...

3 values are there in B2, C2 & D2. How to get Minimum, 2nd minimum & 3rd minimum in E2, F2 & G2. Thanks in adv

Excel 2010 Right now, I am working on a table that is going to count the amount of each part purchased. Then, I want to have a cell that will check which cell is highest, and report a cell that is adjacent to the highest one. It sounds complicated, but the picture should make it make sense...

Hi all How are you? My problem is as follows: I guess it's better to explain my problem with an illustrated problem. I have some circles with radius of 5 meters, and some points that some of them are located in the circles. I want to find that which point is located in which circle. The...

Hey there, guys! I'm struggling with a certain issue a bit. I need to calculate monthly bonuses in Excel in an automated way. Which basically means I need to answer the following question: "If we know minimum and maximum bonus amounts, starting target achievement, and step value, how much the...

Hi. I have a temperature mapping system at work and every day i get exported to excel a spreadsheet that logs temperatures twice a minute. By the end of a week i have several thousand rows that look like this: <colgroup><col><col></colgroup><tbody> 08/01/2014 03:38 15.6 08/01/2014 03:38...

So im not sure if this is possible and i have looked into some different ways of doing this with no success. Im trying to find the minimum of a column, which is simple enough, the problem is that a couple of cells have 4 different numbers in the one cell. Ideally i would like to search for the...