# greater than

1. ### Find First Value in Column Which is Greater Than Specified Value (Searching from Last Value in Column)

I'm trying to find the first value in a column which is greater than a specified number (searching from the bottom of the column). Once that is found, I need it to return data (a date) from a corresponding cell. Because of the dataset, the search must start at the bottom of the column. I've...
2. ### Using the IF Function within Excel

I am trying to work out a calculation within Excel and my values for 'arg' can lie anywhere between -10 and +10. Within a cell, I would like to work out how to use the IF Function to say: If the value of 'arg' is greater than +1, then the value will be changed to +1. If the value is less than...
3. ### Need a formula - filter so 2 columns totalling more than or close to another column only show

Column I in my excel file shows unpaid invoices. Column K shows uninvoiced items. Column P shows the customer's balance on account . Most of the time, P should be greater than I+K. However we want to be able to easily spot the customer files that are close to or have exceeded the customer's...
4. ### CONDITIONAL FORMATING LAST CELL IN COLUMN GREEN IF GREATER THAN ANOTHER CELL

I want the last cell in column L that has a number to be green if it is a larger number than cell D11
5. ### Help with thrid critera with index match and greater than

<tbody> D E F G H New Lamp and/or Luminaire Initial Light Output of new End-User Equipment (lm) New Lamp Circuit Power _Watts Coef Factor Remarks 3 E1.1 A LED Lamp only_ELV 1600 2 0.49 ≤5 W=.0.49, ≤10W=0.41...
6. ### Greater than and less than using conditional formatting?

<tbody> Column H Column I Amount 18/19 Costs £90,000.00 £0.00 £10,000.00 £0.00 £123,300.00 £124,000.00 £10,000.00 £10,000.00 </tbody> I need to highlight the above cells as follows: If the amount in Column H is higher than the amount in Column I then the cell needs to be...
7. ### SUMIFs with criteria for > Greater & < Less than

Greetings Experts, I am currently working with SUMIFS and cannot seem to get my criteria to work. U:U Column = # of days the Alert has been opened (0 to infinity) H:H Column = Process Group (Logistics, Supply Chain, Engineering, Fabrication, Assembly) I:I Column = Alert Status (Open/Closed)...
8. ### less than greater than for large amount of data

Hi Guys I am OK with Excel and I know a way that I can do this, using If and AND formulae, but I feel there must be a neater way to do this given the large amount of data I'm working with would make my formula a bit unwieldy. See example data below: <tbody> A B C E F G H I J 1 Type...
9. ### Need Formula data based on Multiple text/value conditions

Hi Team, Can anyone help me with below requirement....here is the data <tbody> Customer Product Name Amount Contribution by Final Status Cust1 Product 1 17,991 Team 1 Cust2 Product 2 19,901 Team 2 Cust3 Product 3 18,948 Team 3 Cust3 Product 3 10,730 Team 1 Cust5 Product 5...
10. ### VB routine to produce message box if value greater then another

Hi All I'm new to the site. Hopefully I have posted this properly! In the file I'm working in, there are a series of cell into which the user can enter a value of their choice. These cells are all independent of each other so the value are also separate and independent of each other. I...
11. ### If either of two cells falls between 0 and 90, then WJ

At some point I will be able to help more than asking for help. I'm trying to get it so the selected cell will display "WJ" if cell Z2 or AA2 has a number greater than 0 but less than 90. So far I have not been successful at getting it to work. You all are so knowledgeable that it's probably as...
12. ### Pivot table groups a buch of date into greater than

I have a pivot table that seems to be gathering a bunch of dates into a greater than field. I've had this before but its usually just todays date that's the greater than value but this one is >05/09/2017 so theres nearly 2 weeks of data bundled into this value. I've tried refreshing the data...
13. ### If Greater, Equal or Less Than Formula

Hi, I am trying to get a cell to show me the following: If cell AI2 is greater than O2 say "OVER" in cell A2 If cell AI2 is less than O2 say "ACTIVE" in cell A2 Or, if cell AI2 is equal to O2 say "CLOSED" in cell A2 I am currently using the formula...
14. ### Index Match - Multiple Criteria with Great Than

Hi, In this scenario, I need a formula to return a specific value based on (1) a criteria with an exact match, and (2) a range criteria where there is not always an exact match. Table 1 contains the criteria of the lookup (Year and Number), as well as the value I want the formula to return...
15. ### Conditional formatting not working on VALUE

I am working with an exported spreadsheet from an application. I also copied and pasted to a new sheet as text only, but problem still occurs. When I highlight the column range of c2:c100 and set the cell highlight to fill in values greater than 19 (>19) The results are that the cell shading...
16. ### Conditional Formatting, 1 Column greater than the other

Hi all, I'm doing some analysis of data from two measurement systems, I want to see if the two processes are getting results within 10% of the allowed tolerance. The below link is what I'm dealing with in excel. Imgur: The most awesome images on the Internet I'd like to use conditional...

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>...
18. ### Comparing Times in Access

I'm working on an employee schedule. I have folks start and end times as well as break and lunch times. I'm trying to create 1/0 for working/not working in 15-minute intervals throughout the day. My equation looks to say if the interval is less that the person's start time, greater than the...
19. ### Greater but less than formula

Need guidance to how to make this formula read = 0 and Less than 5.00 but greater than -5 so -5><5 Also is there a way to have it label the ones summing to 0 "Zero" and label the ones less than 5 but greater than-5 "Less 5" =ROUND(SUMIFS([Amount],[Financial Complex],[@[Financial Complex]]),2)=0
20. ### If/then with > sign

Hi folks! Hoping your Friday is going well! Today's question is: Under the total column, I want an if/then statement to provide the greater of the two columns, 25. Can someone help me with this please? <tbody> A B Total 25 15 =formula to give me 25 </tbody> Thank you so much!

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back