less than

  1. N

    Using a COUNTIFS formula with a less-than criteria

    Below is the table I am working with. The "Call Sequence" column is just a continuous list of Calls (1 to 2221). There are 11 different call types with 11 corresponding Prefixes. Because there are many calls of the same Call Type I would like to count them. I also want to have the "Suffix"...
  2. D

    How to set multiple criteria for .advancedfilter in VBA

    Hello All, I am trying to use the xlfiltercopy action with the .advancedfilter function in vba to filter through some data and copy it to another sheet. The criteria for the filter, however, will be all values between two variable values that will change on every iteration of the filter, i.e a...
  3. M

    Combine countifs with match for greater than or less than values

    I need to count up all the machines that are less than 181 days old and older than 149 days. I can do this with sumifs, but not countifs. The sumifs formula I used that worked is below. I just need a count and not a sum...
  4. X

    VBA Conditional formatting help

    This is the code that I have for conditional formatting. What I want to happen is as follows Cells that contain numbers between 0 and 1 to be red Cells that contain numbers greater than 1 and less than 100 to be yellow Cells that contain numbers equal to 100 to be green Here's the current code...
  5. A

    indirect and > or <

    i am setting up a report where the user can set certain inputs. These are then used to highlight entries in a report. How can i get something like indirect to bring each of the values from the input cells into my report? as an example: A1=6 A2=< A3=8 I can get the value for a1 and the value...
  6. T

    Formula to Count Data in a Range That is Consecutively Outside of a Specification

    Hello all, I am trying to create a single formula in a single cell that lists the number of times an out of specification condition occurs for greater than two hours. As an example: Time Temp 0:00 -15 0:15 -15 0:30 -16 0:45 -16 1:00 -17 1:15 -18 1:30 -20 1:45 -20 2:00...
  7. B

    Formula needed, stuck and do not know how to proceed!

    Good morning All, Before I start I would like to thank everyone for any help. I love this site and the help I receive is always amazing. I need help getting a formula to do the following... Formula is going into cell B4, if true cell b4 should say "Improved" if false "No Improvement" N4 = Y...
  8. B

    Please Help, Formula Needed

    Good afternoon all, I am in need of some help. I am looking to create a formula for the following. The folrmula is going into cell B4 if N4 = N then cell should be blank. If N4 = Y, and if S4 is <25 days from todaydate leave cell blank "" If N4 = Y, and if S4 Date is 25-35 (>24,<35) days from...
  9. B

    Conditional Formatting depending on number in another cell

    If I have a "1" in column C, and my number in column L is less than 2,000 I need the cell to highlight red. If I have a "2" or "3" in column C and my amount in column L is less than 8,000 I need the cell to highlight red as well. Is there a formula I can put into conditional formatting to get...
  10. C

    Greater Than, Less Than, or Equal To separately NOT combined

    Having a brain lapse on how to do this formula where one of 3 results will be return.. =IF(AND(M1>N1,M1<N1,M1=N1),"GREATER","LESS","EQUAL") The abv formula obviously doesn't work -- too many arguments -- but I don't want to combine and EQUAL TO with a > or <. I want each response separate...
  11. C

    SUMPRODUCT with INDIRECT and multiple criteria

    Hi all, My first post so I hope I've done it in accordance with the rules of the board. :) Question: I have a spreadsheet for football results. So I've got teams on different sheets pulling the data from sheets. I've been using the first formula with no problems but decided I needed away of...
  12. D

    IF Function with greater than and less than

    Hi, I'm trying to get this IF function to work, it's not giving out an error message but using the wrong figure to do the calculation. Checked all the reference cells and can't work out what is going on with it! =IF(H3=1, G3*T3, IF(H3=2, U4*U3, IF(H3=3, V4*V3, IF(H3=4, W4*W3, IF(H3=5, X4*X3...
  13. Y

    IF statement based on multiple conditions

    Can anyone assist? I am trying to combine multiple conditions in a formula, it needs to be a formula and not in access. I have a spreadsheet which simplistically contains three columns of data. Col A - original date Col B - payment date - will contain blanks until paid Col C - delta between...
  14. R

    greater than and less than filtering <x>

    Hi I am having trouble filtering greater than in one range and less than in another range at the same time. If i separate them, they work separately but not at the same time. What is going on and can anyone help. Here is the code below. Sub Filtergreater() Sheets("FolderSort").Select...
  15. O

    VBA Filtering by date

    Hi All I am trying write code to filter for all data before today's date which is contained in a cell. I assumed that it would be pretty basic and that filtering using the "<" symbol would work. It works for standard numbers, but dates don't seem to like it. The filter determines that there...
  16. T

    Help with IF formula to return values based on a value being within a range

    Hi I need help with an IF formula I need to calculate a charge based on the number of transactions for a customer. To explain, the customer gets charged £500 if they do 1000 orders. If they do 1001 they get charged £500 plus 1 times the second bracket- £0.40. Finally if they do 3001 orders...
  17. C

    COUNTIF formulas with dates (<>) in reference to =TODAY()

    Hi Everyone, Very new and inexperienced at Excel ---^ Hence the name!! Everything that I have tried to do before was very elementary and simple, like a budget. I am trying to make an excel sheet for work and I need to count the dates as in greater than, overdue, and less than 1 month away. I...
  18. D

    formula to display a score for a value within a stepped range

    Having trouble with this one - Pls Help me display the appropriate point, when the value falls within the following ranges. Have not been able to find the right vlookup combo. Note: As I will reuse the basic formula for different upper & lower data range values, I would like avoid hard-coding an...
  19. B

    Filter by formula?

    Hello, I would like to filter a column based on whether or not it is 'greater than' or 'less than' an adjacent cell. e.g: should the value in A1 be less than B1, it will show up in the results of a filter. and so on for A2 and B2, A3 and B3... Any ideas? Have I missed something?
  20. I

    Format cell in Colum B if date in Colunm A is over 90 days

    Hi all! Long-time lurker on this forum - I've pretty much always been able to find an answer to a problem as someone else has asked before but can't quite find a solution to this one that works for me. I have a series of dates in column A (representing when an assessment was carried out). In...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top