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...
How do I count a cell if it contains less than 5 characters, or contains digits (even if mixed with letters)?
After data transfer, I have a list - some are email addresses, some usernames, some random text. I want to filter these to username which are less than 6 characters (for example) so us...
Is there a way to get a row to resize if it is below acertain height?
I have my rows in a range set to 38 but I have them autofitting once the day is entered in case the row needs to be taller.
Is there a way for this to either only resize if it is goingto make it taller OR after the AUTOFIT...
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...
Hello and thank you for the help
J3=215, J4=214 and so on to J93
N3=215 and conditional formatting for this cell has 3 rules
Cell Value < J3 (green format) applies to =$N$3:$N$5
Cell Value = J3 (yellow format) applies to =$N$3:$N$5
Cell Value > J3 (red format) applies to =$N$3:$N$5
After much scouring of the threads I have found nothing similar enough to this that I can steal from. I am trying to pull Space and Manifold ID from a chart on a separate sheet based on the date the manifolds were repaired on. The manifolds and space repeat a lot as there are multiple valves...
I work in a business where we have a date driven process. As happens with all data, however, sometimes entry errors happen.
I want a formula that will check to make sure that the second record date (AE) is not greater than the first record date (AC).
However, when I write the formula...
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)...
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:
Hello - I am looking to conditionally format, in a pivot table, a cell based on whether it is more or less than the month before. Sounds simple enough, right? Wrong (at least for me)!
My dataset lists the item in rows, the months in columns, and the sum of quantity in the values.
I want to...
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...
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...
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...
I'm trying to build an equation that will assign a particular value to a data set depending on if that value is <, between, or > than a certain value. Disregard flows for now, that will be coming from a separate spreadsheet. The remaining five categories are all on one...
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"...
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:
I can get the value for a1 and the value...
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: