# threshold

1. ### If greater than a threshold, then average next 200 cells

Hi I have a 2000 rows of numbers in column A. I need a formula to be written that when a number in ColumnA is >= '20', it will then mean the next 200 rows of data and display the mean number in Cell, B1. If has to be the first row which is greater than 20. Thanks in advance, Pedro

Hi All, I have a challenging formula I am trying to create. It essentially incorporates a threshold on profitability. Below I've laid out a simplified version of the data I am working with to help illustrate my problem. <colgroup><col><col span="2"><col><col span="6"></colgroup><tbody>...
3. ### Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached.

Hi - I'm trying to build an output model similar to the one shown below, please see the following explanations to help answer: Main Issues: (I) When a unique ID has multiple transaction with a selected product code input before meeting the selected threshold amount. (II) Once threshold is met...
4. ### Multiple Criteria Conditional Formatting with Threshold

My objective is to establish a conditional format across the table based on a certain threshold establish for multiple categories. Each category will have a different threshold, which adds another layer of complexity to the issue. Below is an example breaking it down. Feel free to ask what ever...
5. ### Conditional Drawdown

Hi I want to calculate drawdown so that I am in a position to ascertain if the following statements are correct: SPX For the period 1900 – 2010, 5% corrections occurred three times per year on average, 10% corrections occurred once per year on average, and 20% corrections occurred once every...
6. ### Percentage thresholds table (How do I recreate this with formulas/excel?)

I'm interested in recreating this table which shows the percentage cut off (or threshold) to earn shares (based on the size of the share pool) based off of volume of sales. The left side of the chart shows the number of shares available to earn. The top row shows the number of shares won. There...
7. ### Return Value from one tab to cell on another tab based on threshold

I have a report that I'm responsible for managing that comes in weekly from several different members of my organization. They are sending certain statistics on each facility of our organization, which I then copy into a tab for the week in a master file and use the information reported by each...
8. ### Counting number of times a maximum exceeds a threshold on a certain frequency

Hi All, this is the first time I'm on this forum - I apologize in advance if my question isn't as detailed as it should be. Anyway, I was hoping someone could point me in the right direction for a macro I am trying to create. I have a set of data that is as following: in Column A I have a list...
9. ### Determine MAX below a threshold

Hi everyone, Quick one I just can't get right I am after a formula that will return the MAX value below a threshold. I have a list of numbers between 0 and 19000 I would like to determine the value that is the highest below 16000. I guess the second thing is a conditional format that...
10. ### HELP, Commission Scedule

I am trying to write a formula to calculate commissions. Employees collect 60% of sales up to a \$25,000 threshold. After the \$25,000 has been paid they collect 100% I am having a hard time getting Excel to calculate the sale at the point they cross the threshold and still accuratly calculate...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...