# Find 2 Corresponding Values & Multiple The Minimum

Jan 10, 2008
Look in Column A and find the cell that contains "Std A 1" and the cell that contains "Std A 2".

Compare the corresponding values in Column B, and multiply the lowest value by .2

I've tried using various methods (find, if cell.value.instr) but I keep getting errors. Can anyone point me in the right direction?

View 6 Replies
ADVERTISEMENT
Feb 23, 2009

I have a range of values, (1,10,20,0,2,5)

I need to find the minimum values, but I want to avoid 0(zero)

View 9 Replies
View Related
Jun 7, 2007

Referring to the post Find Min Value In Multiple Columns And Match The Header. I would like to go little bit further and see is there a way to find and match not just in multiple columns but in multiple tables (see the example)

View 4 Replies
View Related
Jan 4, 2010

Attached is a print screen. I'm struggling with using the min function in vba. I want it to find the minimum cumulative cost in week 0 out of the first three, and the copy the permutations of it (1,0 or 1, 1 , e.t.c.) to Week one column C & D of the model.

View 3 Replies
View Related
Dec 24, 2009

I want in A1 to find minimum SUM if no minimum number in row.

Here is example attached: ...

View 9 Replies
View Related
Apr 24, 2007

I have a spread sheet that needs to compare numbers in a row & hightlight the lowest number in each row.

View 9 Replies
View Related
Jun 25, 2009

I have a set of worksheets all of which are identical and covered by first:last sheets

What I am trying to do is come to up with a minimum figure for cell G30

With the proviso that it is a minimum of 30 as some of the entries in G30 are less than that figure.

=MIN(first:last!G30) is not the answer as it gives an answer of zero.

View 9 Replies
View Related
Jan 16, 2010

I am having trouble with large data sets of rents by market: trying to find the peak rent in a time-series, and then look for the next trough rent in time. I tried using the Newsletter 3 techniques which feels like the right direction, but I am not getting the nesting right or some of the parameters in the functions.

So, within each time-series I need to find the MAX value (peak rent), wherever that is in the array. Then I need to look to the right of that exact MAX value and find the exact MIN value (trough rent), whereever that is in the array (again, to the right of the MAX value).

A small sample of what the data set looks like:

2008 Q22008 Q32008 Q42009 Q12009 Q22009 Q3

Atlanta771773768761749756

Austin770786784779776776

Baltimore947948949950950953

Boston1,6471,6601,6541,6481,6301,613

Chicago998998996985984986

View 4 Replies
View Related
May 27, 2009

I have been trying to solve this problem for the past couple of weeks and I have not been able to do so. I have come to do the operation manually, and it really takes a lot of my time, so if you guys could help me, I would really appreciate it.

Basically the problem is this:

In column "A" I have what I call point numbers for all the data entries.

In column "B" I have the station (or location) at which I vary slightly a parameter (represented by column "E") to give me a value shown in column "D" (the "Z" value, as shown in the sheet).

So basically you can see that my station 0 has 11 different "E" parameters (0, -1, -2.62, -5, etc) and each of them has a "Z" parameter (390.76, 390.775, etc).

What I am trying to do is to come up with a table that shows a summary of the following:

A column with each of the stations (0, 20, 40, etc -- notice that I have some weird numbered stations like 411.89).

Another column with the "E" parameter corresponding to the lowest (or minimum) "Z" parameter within the station range.

And a final column with the minimum "Z" parameter corresponding to its "E" parameter, which is included in the station range

You can see in yellow the way I have been doing this and you can see that it would take me so much time to accomplish the task.

View 7 Replies
View Related
Dec 10, 2009

I have following problem I have some table - 2 columns - in first is text in second is value.

example:

A 10

B 5

C 3

A 15

C 8

D 7

A 9

I need to use formula, which shows me minimal value for choosen text. I tried matrix formula like {=min(if(text table=choosen text; second column;0}, but it's not working

View 5 Replies
View Related
Apr 22, 2014

If I have a range of data say all numeric and range form cells A1:A20. How would I find the minimum value except A4 where A4>0?

I know I can use the 'MIN' function and highlight all the data bar A4 (min(A1:A3,A5:A20) but i was hoping for an actual way so I could later fix the column such that first A1 is the first to be omitted A2 is the second and so on.

View 3 Replies
View Related
Mar 20, 2007

I want to find out the minimum $ amount in a row with multiple columns but some columns will also have numbers that cannot be converted to string.

What formula could I use to only find the lowest $ amount?

View 9 Replies
View Related
Apr 5, 2009

I have inherited some legacy templates (Standard, Leave and Exception) which cannot be changed. I need to summarise them (Total) selecting the earliest start and the latest finish. (Sample attached). The templates are 90 columns wide and about fifty lines deep so named ranges isn't practicle (I think). I'm running 2003.

View 4 Replies
View Related
Dec 29, 2009

I am trying, without success, to create a formula that will refer to a column of data and do the following in one step:

1. Find the minimum value in the range, and then

2. From that minimum value, count back “up” the column the number of occurrences, including the minimum value, until a zero is reached. The zero should not be counted.

For example, if the values in A1:A6 are 1, 0, 2, -1, -2, 1, the minimum value is -2 and the count would return 3. (i.e. 2, -1 and -2)

View 2 Replies
View Related
Oct 17, 2011

How do I find the minimum and maximum numbers in a table if I do not know the size of the table but can assume the user will choose the first cell (upper left cell) of the table and run the macro?

View 5 Replies
View Related
Dec 24, 2011

So i need a way to find the minimum number in a given set of numbers without there being multiple minimums. For example if you had 1,2,3,4,5,6,7 the minimum would be 1. If however you had 1, 1, 2, 3, 4, 5....i want excel to recognize there are multiple minimums (two 1's) and produce a warning (i realize this probably needs to be coupled with an if statement).

View 3 Replies
View Related
Nov 9, 2012

I'm looking for a formula to find the minimum value in a non successive range of numbers (excluding zero values).

My sheet contains four fields of numbers (#1, #2, #3 and #4) and than start over again with number #1, #2, #3 and #4 etc. This goes on for approx. 25 4-column blocks. A simple MIN-formula or SMALL-formula doesn't seem to do the trick as it takes all values into account, not just the #1 or #2 or #3 or #4 values.

Example (cells A1..A24):

999-999-999-999-110-120-130-140-111-121-131-141-112-122-132-142-0-0-0-0-113-123-133-143

The minimum value of #1 (excluding the zero's) would be 110, the minimum value of #2 would be 120, #3 would be 130 and #4 would be 140.

View 4 Replies
View Related
Mar 10, 2009

I have a table that contains various aspects of information about customer cases, and I want to replicate a user 'picking up' the case by a simple press of a button.

Users have access to only one Country, so I want to be able to search a particular column for the lowest value, but check that the Country for that row matches the user's access. If it doesn't, I then want to find the next lowest value in the column, and this is what's perplexing me??? As mentioned, I want to click a button to trigger this, and therefore want to use VBA code.

View 7 Replies
View Related
Jul 5, 2011

Is it possible to find the minimum distance between two points using two separate lists of different lengths without creating separate columns of equal row sizes

? I am trying to find the shortest distance form one point to another which is a fixed value. I am using the standard distance formula: =SQRT(((X2-X1)^2)+((Y2-Y1)^2)+((Z2-Z1)^2)).

My X1,Y1, Z1, has 2,000 rows in three columns that need to be compared to find the minimum distance from my one row/column of X2,Y2,Z2.

Is there a command that could go through and use each row of the X1, Y1, Z1, while looking for the MIN of the above formula without having to create an equal amount of rows for the X2, Y2, Z2?

I know I could do it by running this out the long way and then finding the min after I do all the math but I am wondering if there is an automated way for Excel to go through and do the forumla and then only return the MIN value?

View 8 Replies
View Related
Mar 24, 2014

Daily At the end of day We receive sales files from our different teams, these files are received at different times due to difference in working shifts. I have collated last one month data and from this data I want to know the earliest and maximum time and date on which we received the files in last month, so that i can fix the receiving time for all regions.

View 5 Replies
View Related
Sep 19, 2009

I have a range of cells (say A1:D8).

I wanna find the address (say $B$2) of the minimum value in that range.

This command does it but it only works on a column. it does not accept a range spanning more than one column.

=CELL("address",INDEX(B2:B7,MATCH(MIN(B2:B7),B2:B7,0)))

this will tell me the address of the minimum value.. but in a column... I need a range of many columns.

So I tried converting things to a Table.. but it never worked. basically the MATCH command is my problem. It only accepts single-column-ed ranges.

View 13 Replies
View Related
Mar 18, 2009

I'm trying to use solver to find the minimum value of a cell by changing 5 separate cells. These cells are subject to a set of constraints that are formulae. On top of that I have a large number of these solve's to run (The spreadsheet is creating randomly distributed data to form a Monte Carlo simulation). Therefore I am referencing the formulas using the ActiveCell, Offset() function. For some reason when running this code none of the values are changed. Also I changed the UserFinish to false so I could see what solver was doing at each solve, It stops at the correct cell (one after the final cell) but without me having to confirm it each time.

Here is the ....

View 3 Replies
View Related
Aug 5, 2009

I have run into serious trouble with a file I am working on. I have 12,000 companies (roughly), and each of them appears in an Excel file multiple times (some 1 time, other 18 times) with a few parameters. The big file (about 90,000 entries) is sorted so it looks like below:

I will illustrate for 2 companies:

Company A 0 200

Company A 0 0

Company B 300 400

Company B 0 50

I need for every company to do a countif for each column on condition

that the value is larger than 0.

In this case I would end up with:

Company A 0 200

Company A 0 0

Countif result 0 1

Company B 300 400

Company B 0 50

Countif result 1 2

However, I need to extend this to the whole 90,000 entries and 12,000 companies and this cannot be done manually. I thought about vlookup but that returns the first entry only, and I have multiple.

View 4 Replies
View Related
Feb 18, 2014

What I'm looking for is a formula that will search a data table on a source tab and find a value in a column. And have the ability to function like a vlookup and display the contents of cells in the same row on a different tab. The catch is the value will repeat it's self at random interval in the data table. So for example the values are ON-1 to ON-8 and MB-1 to MB-8. Each value will have it's own tab and I want the formula to search the Source tab and capture the value in order but on the next row of the spread sheet.

View 4 Replies
View Related
May 12, 2009

I have 2 columns, A (has the names of employees) and B (has the month in which the employee has a project scheduled). What I’m looking to do is find the latest month an employee has a project scheduled. Note: Employees can have a multiple number of projects so they may be listed multiple times with corresponding months.

I have each employee listed in column F and am looking to find their latest project month in column G. (I have the number that the formula should return in column H).

View 3 Replies
View Related
Aug 12, 2006

I am looking to find a cell value on a spreadsheet that has cells with multiple values listed in it. For example. If I CTR F for i.e. (745) on a spreadsheet that has this value in a cell that contains i.e. (684, 362, 745, ABC) all in one cell I get a no results. Ultimatelly, I'd like to run a Vlookup function on this file.

View 7 Replies
View Related
Dec 8, 2006

I have looked on here and I can find the minimum value in my range but what I am trying to do is find the minumum two values. Or rather, i want to find the average of the remaining values.

If the lowest value happens THREE OR MORE times, i still only want to exclude two of them. Same thing goes if the second lowest happens more than once, i only want to exclude at most two values from the avg.

currently, i have 12 values in my list.

example:

list --> one in each cell going across

25, 50, 87, 56, 99, 80, 81, 82, 50, 100, 98, 99

i have the answer as 83.2 doing it by hand. the 25 and one of the 50s would be dropped and the rest would be averaged.

View 3 Replies
View Related
Jul 4, 2007

i have found this code on ozgrid to search between a min max value, trouble is it only selects the first cell it finds. How can it be modifide to copy each value in between the min max set say to sheet 2?

Option Explicit

Private Sub CommandButton1_Click()

Dim strNum As String

Dim lMin As Long, lMax As Long

Dim rFound As Range, rLookin As Range

Dim lFound As Long, rStart As Range

Dim rCcells As Range, rFcells As Range

Dim lCellCount As Long, lcount As Long

Dim bNoFind As Boolean

strNum = InputBox("Please enter the lowest value, then a comma, " _

& "followed by the highest value" & vbNewLine & _

vbNewLine & "E.g. 1,10", "GET BETWEEN")

If strNum = vbNullString Then Exit Sub

On Error Resume Next

lMin = Left(strNum, InStr(1, strNum, ","))

If Not IsNumeric(lMin) Or lMin = 0 Then...................

View 5 Replies
View Related
Aug 23, 2013

I have 2 sheets that i need to find what the same valued cells are.

1 sheet has names and i need to find the rows where those same names are on the 2nd sheet.

The formats are different (upper-lower case) and there is additional text as part of the cells in the 2nd sheet. (i.e prod123.web.corp.com) and i just need to find the prod123 parts.

View 9 Replies
View Related
Mar 24, 2014

Column A:

pants A green

Pants B red

Jacket C green

Jacket D blue

Polo C white

....

I need a formula to find some value( in our case "colors" = "green, red, blue, white" ... = 20-30 values), and to return in column B, the values, like:

Column A: Column B:

pants A green | green

Pants B red | red

Modern green Jacket | green

blue winter jacket | blue

Polo white D | white

I have different product feeds (csv) and i will like to search for colors in the product names.

View 2 Replies
View Related