Finding Lowest Percentage From Peak High To Low?

Aug 30, 2013

I had the following:








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


Finding Peak And Trough For All Points In Graph

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

Look And Chooses The Lowest Percentage

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

Find Lowest Percentage In A Series Of Numbers

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

Find The High Price Day Of Each Week. Then Report The Median High Day

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

Conditional Format The List So That It Shows The Lowest Percentage In 'green' And The Highest In 'red'

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

Finding The Lowest Value And Highlight With Condition?

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

Finding The X Highest Or Lowest Numbers In A Set?

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

>>> Finding Lowest Cost/Vendor

Oct 24, 2007

I need to find the lowest price, mark it up and designate which vendor its 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.

Heres 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

Finding Lowest Value And Displaying Offset

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

Finding Highest And Lowest Values In Dynamic Range?

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

Finding Percentage Of A Range Of Values

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

Finding Cumulative Percentage In Pivot Table?

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

Finding Percentage For Cells That Contains Specific Month And Status

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

Excel 2007 :: Locate Peak Values In A Column Of Numbers

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

52 Day High/low

Mar 4, 2007

I am trying to calculate the 52 day high/low for a stock in excel.

View 9 Replies View Related

Sort High To Low

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()
Application.CutCopyMode = False
End Sub

View 9 Replies View Related

Macro To Remove Rows That Contains The Phrase "Off Peak" And "Weekend"

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

View 9 Replies View Related

High Scores And Tiebreaker

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.

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

Low And High Numbers With Stats

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

Sort The Addresses From Low To High

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

Conditional Format For Low, Mid & High

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

Find Intermittent High Value

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

Rows High For Only Cells That Have Some Data

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

Picks Up The Drifferences Between Low And High Numbers

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

High Frequency Data Calculation

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

Add High / Low Points To Line Chart?

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

Chart: Plot High And Low Data Only

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

Weighted Average Excluding High/Low

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?


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

Lookup Number Between High/Low Range

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

Copyrights 2005-15, All rights reserved