less than

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"...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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?

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...