Finding Lowest Percentage From Peak High To Low?
Aug 30, 2013
I had the following:
0.000%
-2.140%
-1.729%
0.973%
1.206%
1.469%
[code]...
I want to know the lowest number from the peak high to the lowest low was? If I have not explained that properly, if I had 12.00% as the highest and the next few rows consistently, and gradually moved to a low of 8.00% that would be a difference of -4.00%. So -4.00% would be my answer. formula as I need to know this one number in a column of 4000+ percentages like you see above.
View 9 Replies
ADVERTISEMENT
Apr 30, 2014
I need to find the Peak and Trough for all the points in the attached graph and the data point used for plotting it. How do i find it.
Attached Image : b.png‎
Attached File : A1.xlsx‎
View 6 Replies
View Related
Dec 4, 2007
I am looking for help to solve the following:
I have a list of percentage. I need a function that looks at the list of percentage (each percentage is in it's own cell) and chooses the lowest percentage.
ie: 100%, 50%, 88%, 66%, . . .
Result should be 50%
View 9 Replies
View Related
May 27, 2014
I have a series of numbers in cells B2 to G2. The maximum value of each of these columns is found in B5 to G5. Is there a formula that will calculate the percentage of each of the values in row 2 (B2 to G2) and tell me which is the lowest number based on the percentage? Example...
Row 2: 12, 100, 43, 1444, 141, 332
Row 5: 25, 140, 55, 3000, 244, 440
Which number in row 2, is the lowest percentage of the total possible points found in row 5?
B2 is 45% (12 divided by 25), C2 is 71%, D2 is 78%, E2 is 48%, F2 is 58%, G2 is 75%.
I want a formula to tell me in a new cell that "12" (in B2) is the lowest percentage in that series.
View 4 Replies
View Related
Aug 14, 2008
I have an interesting problem (I hope you find it interesting too). I'm trying to find the historical "high" day of the week for a particular stock I follow. I searched for several hours but was honestly unable to make any progress. Normally I do my own formulas, so other than pasting a rare macro, that's pretty much the extent of my (lack of) experience, ie please assume I am a novice....
View 9 Replies
View Related
May 13, 2009
I have a list in column A of percentages (to 4 decimals 0.0013) i need to conditional format the list so that it shows the lowest percentage in 'green' and the highest in 'red'.
View 5 Replies
View Related
Feb 3, 2014
question 1 : In the below sheet, is there a way to use the condition highlighting the quantity for each item which has the lowest (prices/pcs) value?
for example : comparing the ITEM 1 -> $8/10 , $6/8, $9/20, $11/20
and highlight the 8pcs for item 1, indicates item 1, seller bill has the best offer.
Question 2 : Since I will have at least 50 items, is there a way to just copy the formula and apple to each row ?
question 3 : I would also like to apply a formula that can calculate the price and quantity of each item. for example : on the I column, for Item 1, i would love to order 3 orders, since bill has the best offer, so I will have 24pcs on column I3. And i would love to apply such formula to each item for each row.
Question 4 : For the cell J3, I would like to know if bill has the best offer for the item 1, order 3 orders, the price for item 1 will be $18. And I would like to apply such formula to each row for each item.
I do not want to create another column for each seller: such as ($/pcs) to find out the best offer, since i will have at least 35suppliers , and try to make the sheet look as nest as possible.
View 1 Replies
View Related
Jul 24, 2014
I am looking for a way to find a highest (and/or) lowest value in a list of numbers. The list keeps getting longer and after a certain point I will need the 2 highest (or lowest), then the 3 highest (or lowest). I know MIN and MAX will find the high and low, but how do I find the 2nd highest, etc?
View 3 Replies
View Related
Oct 24, 2007
I need to find the lowest price, mark it up and designate which vendor it’s from so the CSR knows which one to quote back to the customer. Besides going through it line by line, is there a way to do this? It seems like there could be a formula where it pulls the lowest of the 3 prices and vendor name into a new “price” and “vendor” columns and then I can go through and mark it up.
Here’s a small sample of what the sheet looks like:
Item #Desc V1 V1 CostV2V2 CostV3V3 Cost
123456brush Advance 2.56Weiler5.65Osborn3.25
View 2 Replies
View Related
Jul 20, 2012
I have a spreadsheet where I want to do some fancy stuff:
1) find the lowest value in a range of cells (S9:S17)
2) output its corresponding value in A9:A17 into another cell, say C87
3) increment its corresponding value in C9:C17 by 1
4) repeat 9 times, but inputting it to C88, then C89, and so on.
Everything in the spreadsheet depends on the values in C9:C17, including the range S9:S17, so when the values in column C change, so do the ones in column S.
But I don't want to actually change anything, just simulate it. But because the values in S9:S17 are formulas from yet another column in the spreadsheet, the best thing to do would be to remember the column C values beforehand, do the 4 steps above, and write them back afterwards, otherwise the macro starts to get complicated and brings in more values etc.
View 2 Replies
View Related
Dec 28, 2011
I have a column that updates automatically by placing a value in in the next blank cell in the column. I am trying to write two formulas to identify the highest and lowest values in the preceding 10 cells of each update in the column but seem to be stuck in MIN/MAX/OFFSET hell.
View 8 Replies
View Related
Feb 13, 2009
I have a little table:
Columns A:B (separated by commas)
Row 1- Year One, 20
Row 2- Year One, 20
Row 3- Year One, 10
Row 4- Year One, 30
Row 5- Year One, 20
Row 6- Year One, 20
Row 7- Year Two, 10
Row 8- Year Two, 20
Row 9- Year Two, 20
Row 10- Year Two, 10
Row 11- Year Two, 20
Row 12- Year Two, 40
In the adjacent cells in columns C (C1:C12) I need a formula that would turn the value into a percentage of the total of the values for that year (e.g. in C1: 20 is 16.7% of 120, so the value displayed would be 16.7% (or 0.167)).
View 3 Replies
View Related
May 21, 2014
I have data of supplier spend and need to find percent of suppliers having top 80% spend.
How to get the cumulative spend within the pivot table itself. I can do it outside the table by calculations, but how to get the results directly using pivot table, because i am using that data in a KPI metric and a dashboard.
if not possible in pivot table, can i get it in a single step process using percentrank or percentile formula or anything else?
View 6 Replies
View Related
Jan 2, 2014
What formula I should use for this condition:
A (Contains many months, e.g. 3 November, 2 December, 10 January, etc. -- in excel date standard format mm/dd/yy)
B (Contains Paid, On process & Waiting for Invoice -- using IF formula)
I want to calculate the percentages of November that has been paid from all of A that contains November in it in column C.
What formula i should use?
I already use =SUMPRODUCT for counting the November.
I only want to use 1 other column to calculate the percentage (C column)
View 4 Replies
View Related
Nov 8, 2013
In the attached spreadsheet I would like to locate the peak values of the numbers in column "F". I don't know if this is best done with a series of functions or by using a macro.
Column "F" translates to the light blue line on the attached chart. Column "F" (MACD) is the difference between a 12 week exponential moving average (EMA) and a 26 week EMA.
I would like the peak values from column "F" re-stated into column J,K,L or M. Ideally I would like to find the highest peak that occurred in a rolling 12 weak period. So not all peaks would need to be posted. By doing this I would only be identifying longer trends .
I'm using Excel 2007. 25 years experience using Excel and functions. Limited experience with Macros though long ago I used to write C code.
View 3 Replies
View Related
Mar 4, 2007
I am trying to calculate the 52 day high/low for a stock in excel.
View 9 Replies
View Related
Mar 28, 2009
I have the following table...
NameQuestions correctQuestions WrongENTERPositionNameQuestions correctQuestions WrongPoints1dave6216203ben531240506jan712070809dan802410011fred44812tom354
When the data is typed into the top box, I have a macro for the "enter" button that places the data into row 12.
What I really need is after the data is placed into row 12, is for the table to be sorted highest points to lowest points, and if scores are the same then in alphabetical order.
This is my macro......
Sub Results()
Range("C9:E9").Select
Range("E9").Activate
Selection.Copy
Range("C23").Select
ActiveSheet.Paste
Range("C9:E9").Select
Range("E9").Activate
Application.CutCopyMode = False
Selection.ClearContents
End Sub
View 9 Replies
View Related
Feb 27, 2009
I have a spreadsheet with about 20,000 lines. (The number of rows fluctuate) I need a macro to remove (delete) rows that contains the phrase "Off Peak" and "Weekend"
I was setting it up in a loop but I don't know how to make the loop end after ALL the "Off Peak" and "Weekend" info is removed.
My macro just does a find then delete the row and then loop to the find again. Is there an easier way and can the "Off Peak" and "Weekend" statements be combined into one search
Do While
Cells.Find(What:=" Off Peak", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Select
Selection.EntireRow.Delete
Loop
View 9 Replies
View Related
Oct 1, 2009
This is for a forestry contest. Students compete in 6 different categories (columns B through G). Teams can have up to four members and the top three member scores are taken to determine a team score. Teams are then ranked. Here is where I need help. I would like to be able to find the high individual score for each category in the contest. (sawlog, pulpwood, tree ID, etc) If there is a tie in the category it is broken using the category in the column to the right. Example – sawlog 1st tie breaker is pulpwood, the 2nd tiebreaker is thinning. The last column, Compass, uses sawlog as 1st tie breaker and pulpwood as 2nd tiebreaker.
Example
Will on the RHS team had a score of 112 in Tree ID and a score of 48 in thinning.
Michael on the WHS team also had a 112 score in Tree ID and a score of 44 in Thinning.
So Will is the high individual in that event –
How can I create a formula that will bring the winners name down to row 66-71 and also bring the score down to row 66-71 to show who won each event? example spreadsheet attached.
View 3 Replies
View Related
Jun 6, 2009
I seem to find myself stuff on this project yet again, JBeaucaire was able to help me to get this far im hoping you will be able to help me with the next step of this project
The doc iv attached is able to give me the differnece between low and high numbers with this example low numbers being between 1-18 and 19 – 36 high numbers and 0 being a break if u test the project u will understand im now trying to create a pattern of 3s were im abe to get stat hits on for example the patterns of 3s are the following(numbers) low,low,low-low,low,high-low,high,high-low,high,low every time I type in the numbers 3 times in a row on the 3rd one I want it to show as a hit(success) if the 3 numbers I type in are not a hit like high,high,high I want it to show me a miss if it is a pattern I want it to show a if theres a 0 it must rest like from 0miss,4hits,o breaks to 0miss,0hits,1break and so forth im also wondering if at another part of the form it can keep the total stats like iv added In the doc
View 14 Replies
View Related
Jan 4, 2008
I have voter registration pdf where I can open the table of info into excel when I can edit it. When I try to sort the addresses from low to high. example I have 3 main st, 20 main st, 78 main st, 300 main st. When I try to use sort to arrange them from low to high it does not work correctly do you think I am having a problem when adobe opens it to excel or am I doing something wrong?
View 9 Replies
View Related
Jun 13, 2007
Sorry I don't mean to bring up old post of mine but my boss wanted me to change how this works. I have placed a link to the old post of mine in hopes that it may help. Instead of having two conditions that turn green, he wanted to combine those two, have the lower turn red and the higher turn yellow. Still only three colors but I am unfamilar with how these conditional formats work.
View 9 Replies
View Related
Jul 8, 2007
I am analysing market data to determine when trades should take place and when they should be closed. This works well. But I need to find the intermittent high value between the dates for purchase and the closing trades, and then insert these values in column S in the attached worksheet.
I don't know if a function can find these values or if a macro is needed (or if I should amend the existing macro that currently finds the
closing trades).
This macro is included in the attached spreadsheet. It Is:
....
View 9 Replies
View Related
Jul 31, 2014
I need a VBA code to adjust Rows high for only the cell has data in it.
View 4 Replies
View Related
Jun 5, 2009
picks up the drifferences between low and high numbers for example 1-10 is low 11-29 high and 0 is a alternate so say i start typing in 1,2,3,11,15 in the top cell they start decending down the rows automtically and the program has 2 boxs indicating 3 lows and 2 highs and wen i type in a 0 it resets the two boxs to 0
View 5 Replies
View Related
Oct 16, 2009
Suppose you have a large database, which consists of high frequency minutes data, you need to calculate differences in values between each different time intervals, e.g. from 1 min to 10000 mins.
the format is looked like below
1 min aaa
2 min bbb
3 min ccc
4 min ddd
.................
......................
More specifically, what I am supposed to do is to calculate aaa-bbb, bbb-ccc, ccc-ddd, and then aaa-ccc, bbb-ddd, and then aaa-ddd and so on.
I know the VBA has a function to do repeated executions but am not sure how to adjust the time intervals.
View 9 Replies
View Related
Aug 23, 2013
How to add high/low points to a line graph, similar to what sparklines have. The file I am using now doesn't allow me to add new columns of data, so I'm trying to figure something out that just updates dynamically using the data I already have in place.
This page has the thing I want to do, but it requires additional columns to be added to work, which I don't want:
Excel - Show High/Low Points on a Line Chart
View 2 Replies
View Related
Aug 12, 2008
I have a 46000 rows of data. I want to make a chart, but only want to plot the highest and lowest data points in the data set. How do I get Excel to automatically find and plot only the highest and lowest data points?
View 9 Replies
View Related
Jan 6, 2009
I'm trying to calculate a weighted average excluding the top and bottom value, and am having trouble creating a formula that can be dragged across.
my values are in E2:L17, and the weights are in M2:M17. Basically I want a weighted average of each column, using M2:M17 as the weights.
I'm sure someone's done something like this before, care to assist?
Example:
Data: 1, 2, 3, 4, 5
Weights: 3, 4, 5, 6, 7
Weighted avg ex hi/lo: (2x4+3x4+4x6)/3 = 44/3
View 9 Replies
View Related
Aug 25, 2006
I have two columns of numbers (I'm going to call them Column A & Column B). There are 23 rows with these numbers. There is another column (Column C) which is also 23 rows of numbers. I am trying to find a way for a designated cell that falls between the two numbers in Column A and Column B to display the number in Column C. The numbers would work their way across the row. For example, if cell A1 had a value of 1 and B2 had a value of 10 and cell c3 had a value of .034, if the designated cell has a value of 7, I would want the cell below the designated cell to show the value of .034. I can't use the if/then function because of the 7 limit. I also can't use the vlookup because there is a range of numbers instead of an equal to.
View 4 Replies
View Related
