ifstatements

Hi all, I am needing assistance with my code. I need the macro to go through files in a folder that contain vendor contact forms. I need to copy certain cells from each file (there are hundreds of files) and paste them into a master sheet. The fomats of the vendor contact files are different...

I am looking for the right input for the bleow. I am struggling to get my head round this one, however I know it will be simple for somebody out there. Please see attached image. All will make sense. Sheet 1 column D, If Column A is listed in Column B of Sheet 2, reference column E (of the...

Date of review Checks on ACTION 01/25/22 1/22/22 N/A 1/22/22 1/25/22 TRUE 1/23/22 1/26/22 FALSE IF Date of review is before Checks on and action is true = Pass IF Date of review is after checks on and action is N/A = Pass IF Date of review is before Checks in on and action is false =...

Hello All! I'm trying to create a formula that counts the number of unique dates within a date range based on the type of item. I've tried several different formulas and researched ways to do it, but each formula was so specific to the poster's specific problem, that it did not work so I...

Hello there experts, I have the following code that successfully returns the values of any cells in column A starting with a letter A to Z: =IF(AND(CODE(UPPER('PL & BS Leadsheets'!A5))>64,CODE(UPPER('PL & BS Leadsheets'!A5))<91),'PL & BS Leadsheets'!A5,0) The range in sheet 'PL & BS...

I am trying to get an if statement to sum based on certaincriteria. I have attached a screen shot for better understanding. Essentiallywhat I want to achieve is this. In my screen shot Cell U4 is the sum of CellR4:T4 This is fine but what I want to incorporate is that if Cell O4 contains"yes"...

Good day, I am using a special string to group a result of 3 columns which works perfectly. I have applied this formula up to 100 rows for future expansion, however the rows that contain blank cells where it checks still report. How can I use the below function and avoid having empty cells...

<tbody> Cost per month %Allocation Start Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1000 50% 1 </tbody> Hi everyone, I hope you can help me with the formula. My logic is if Start month = 1, then Jan - Dec = Cost per month* %Allocation if start month = 2, Jan = 0...

So I need to capture the Name and corresponding Total. Notice that the Employee total is varying cells below the name - For Bobby Jones its 3 down and Ricky Bobby its 4. For example the desired data would read like this: <tbody> A B 1 Bobby Jones 300 2 Ricky Bobby 1,100 </tbody> The...

Hi everyone (I'm new)! I have an issue I cannot seem to figure out. -So I have 2 cells, B1 and B2 say. -If B2 is 0 I need B1 to stay 0 as well, but I need an error message to pop up if someone changes it. -If B2 is >0 B1 can be whatever manually entered number you want. So my steps to...

Hi, I am trying to solve a scenario on excel but not sure what formula to use. What I am trying to achieve is if a work item is completed within 7 days they receive 5 points, if within 14 days then 3 points and if more than 14+ days than 1 point. <tbody> A B C D 1 Work Item...

<tbody> Hi, I have a table below of issues that have been resolved and not resolved. I want to create a criteria to allocate points if it falls within a certain percentile. % Resolved % Unresolved Points 27% 0%...

Hi everyone, I am looking to write a VBA defined function that is similar to IFERROR(Action, what to do if error) instead mines would be IFNEGATIVE( Action, what to do if negative). If I could create this, it would cut down on the number of IF's I have for a formula. Thanks in advance, Jean

So I have a bunch of duplicates and uniques. I've marked all duplicates with numbers ranging from 1-10 depending on how many duplicates there are. After this, on a different sheet to confirm which quantities are unique and which have duplicates I put...

Trying to incorporate ="NA","", in this formula, having no luck. I want it so when the match-index retrieves a text "NA" it leaves the cell blank. But still wanting to leave the ERROR.TYPE function in there for future values to be #N/A. =IF(Key!$C$10>=$G1158,(INDEX(page!$1:$1048576...

I want LD2=100 provided EL2 is not equal to 1 OR EL2 is not equal to 2 OR EK2 is not equal to 1 OR EK2 is not equal to 2 How to achieve? Thanks in advance.

Can someone help me with a formula in column D to generate 'Result' meeting 3 conditions? Thanks in adv. Sheet1 <tbody> A B C D E F G 1 Result Condition 1 Condition 2 Condition 3 2 300 400 500 1 A<b< td=""></b<> B<c< td=""></c<> A<c< td=""></c<> 3 300 600 500 2 A<b< td=""></b<> B>=C...

Hey all, I am stuck on this formula. So I created key to lookup and match a type a for a month to get a value. Some the keys do not have a value (meaning key is non existent) for a month so it returns as #N/A in the cell. This is the lookup formula I have...

Hi All, I'm just needing help with putting together a Vlookup, IF Statement & Countifs formula. Basically I have the following sheets:- - Customers (3 column table: Long Name, Acronym, Other Name) - Incidents_Open (4 column table: Incident Number, Inc Organization, Sev, Type) - Team...

I need to find the countifs of two seperate variables and put that result in the adjacent cells. Basically, trying to find a way to pin point where the last two variables reside in the two seperate countif ranges. Data will be added in anytime ex. rows (7-11) and columns Y and AA <TBODY> Y AA...