Hi,
I'm trying to figure out how to test multiple conditions with IF OR.
I have a table like the one below where 7 conditions are checked. Now I want to create a formula that checks all of the 7 conditions and returns TRUE if any of the 7 conditions are TRUE. If all 7 conditions are FALSE...
The old thread here on Mr. Excel does mostly what I want to do: hide rows WITHOUT Macros in Excel.
However, I want to do something a little more expansive. I know nothing about VBA, so I need a little help, as I tried to add multiple criteria to the code above and it didn't work.
I have a...
Hello,</SPAN>
I have a two part question I’m hoping someone can help with. My brain is so fried at this point, I can't think straight about this anymore! :eeek:</SPAN>
How do I update the formulas in the Total column (B) to only count one instance of a “Name” on the data (“raw”) tab (also...
So I've got this far:
{=IFERROR(INDEX($B$9:$B$496,SMALL(IF($C$9:$C$496>G$507, +IF($C$9:$C$496<g$508,row($b$9:$b$496)-row($b$9)+1)),rows($b$9:$b9))),"")}
We are dealing with a list of Standing Order payments from customers. Each has a different day of the month. I need a way of finding which...
I am hoping someone can help with my formula problems.</SPAN>
I can easily edit a formula to apply to all of the needed items/calculations (a few listed below). I am just including more than one because when I thought I had found the correct formula because it returned 0 when 0 was correct, I...
Hi,
I am trying to find INVOICE ID for all Invoices shipped for each SKU after a certain cut off date. I have a list of over 1000 SKUs with multiple cut off dates for each SKU in Sheet1. The invoice shipments data along with the dates is in Sheet2. I have tried to create a Pivot table and used...
Hi,
I'm running analysis of data that includes delivery times for two distinct store types (stores under 3000 and over 3000). Each delivery is distinguished by "Run" which can repeat for different regions (see example below). What I need to find is relative position of stores that are over 3000...
Hello!
I am trying to highlight the row in green that if column e is greater than 500 and column f is greater than 5. also highlight in yellow if column e is less than -500 and column f is less than -5. Also if there is a zero in both of the cells I do not want it to highlight at all.
(C)...
I have a large dataset and I need to count the number of unique entries in one column, if it belongs to one group or another (it is indicated in another column, e.g. it may give group ID of 23 or 34 or 193 etc). Ideally, it would be a formula which I can use across many entries (need to do this...
Hi, I'm a bit stumped, any assistance would be appreciated. I'm trying to return the values "Hard", "Instructional" or "Independent" dependent upon a number of conditions from a student's reading test.
The formula needs to first determine whether they completed a task from A to K (alpha...
I need to count the number of unique offices by summary position=Associate, fiscal year=2014, offer acceptance date>0 and school=I1 (which is a drop down box for all the schools we recruit from). Please help! I've been scouring the web for hours. My ranges are named, I am able to come up with a...
More information
I am trying to have a cell return a value based on multiple conditions. From the table below:
<tbody>
A
B
C
D
1
Project
Origin
Destination
miles
2
Alpha
washington
california
1500
3
Alpha
michigan
california
1000
4
Alpha
atlanta
ohio
750
5
Alpha
chicago
ohio
356...
Hi Guys...
Please help, I'm trying to use the =AND formula to conditional format values in E column based on multiple conditons. e.g If E1 is equal to (Condition 1 is E1>= B1 )and (condition 2 is E1< C1) colour cell red.
<C1) green.
So the formula I'm trying and excel is rejecting is...
My table may have either This or That in column B.
Column B
This thing
That thing
Ain't no thang
And another thing
Are you going to eat that
This I no big deal
That is a lie
I need a formula in Column C which will return "Eureka" if either "this" or "that" is in column b.
For some reason my...
Greetings,
I could certainly use some expert help with this formula. I am trying to accomplish the following:
If Cell H7 < 0, then put in "q"
If Cell H7 is greater than 0 and less than 1, put in "u"
If Cell H7 is greater than 1 and less than 5, put in "{"
If Cell H7 is greater than 5, put in...
I am new to the forums and am teaching myself VBA. I am trying to paste cells from an input tab, send them to the appropriate tab which is the variable, Tabref. When the macro finds the correct tab, it will then match criteria in 3 separate columns, which are Abbrev, Merchant ID, and Amount...
I am looking for the best way to use conditional formatting in a Gantt chart. I want the cells to turn blue if they fall between two dates. Any help would be greatly appreciated!
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 There,
I was wondering how I would go about making condition variables to use in IF statements. The end result of the code is to calculate the total number of hours that a project has been worked on based on a starting time and date and ending time and date. However, there are two breaks and...
Good evening all,
So what I am trying to accomplish is summing data from one sheet (DATA for example), on a second sheet (SUMS for example) if specific conditions are met on the data sheet.
I also want to make sure I am summing the data for only the matching number on the SUMS sheet. There...
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.