condition

Hello all, very grateful for any assistance in helping me complete a formula. I have a 3 cells. Cell A1 contains the date for logging an issue, Cell B1 contains the date an issue was completed and cell C1 contains the status (either pending or resolved) based on which cells have dates in. If...

Good day, is there a way to make an IF statement, row per row? The condition is that A2 is blank, then if will look at A3, if still blank, it will proceed to A4, etc. Thanks

I have `ThisWorkbook.Sheets("MAIN")` and ActiveX `ComboBox11` on it. I also have table: A B 1 John 1 10000 2 John 2 20000 3 John 3 20000 4 John 4 10000 5 John...

Hello. How can I join 2 formulas into 1? I have this: =SE(AZ8=0;0;AZ8-$AX$6) And I want to create a formula with that same exact formula but with a condition on it to either use one cell value or another. I have this and it works but I want it to show nothing or 0...

Below is the data set. I'd like to use the formula under the Rank column -- to rank by sales under the same Item#, and the same item # that has the same sales needs to have a different rank order. <tbody> Item # Sales Rank 101 8 2 101 6 3 101 6 4 101 10 1 102 2 4 102 6 1 102 3 3...

Hello, I would like to have a Userform in Outlook that I can call up to insert a unique identifier (eg. A barcode) and have it reference a specific excel file, and display some finite pieces of data based on that excel file reference (eg. Country, product, shipping condition, etc). How can this...

Good Day Please can I get help with the following query I have the following cubeset formula and I would like to add a condition but cannot get it to work: below is the formula: =CUBESET("DD_MA","{ ORDER( { { { [Product].[Product].[Womens]} * {[Location].[UDA Brand].[All UDA...

Good Day Please can I get help with the following query I have the following cubeset formula and I would like to add a condition but cannot get it to work: below is the formula: =CUBESET("DD_MA","{ ORDER( { { { [Product].[Product].[Womens]} * {[Location].[UDA Brand].[All UDA Brand].[Brand1]}...

Hello to all, I have the table below. Maybe someone could help with this with a VBA macro. I have an Array formula that ouputs almost correct the desired output, but not completely. In column A I have the Country Codes values and in column B corresponding description for each value (ZONE)...

Hi, i have this IF formula that evaluates 2 condition and I would like to add a third condition if none of previous condition are true to leave cell blank or the text no amount to pay. here is the formula: =IF(C21<i21,c7& ","="" &"="" will="" pay="=====">>> ",H13&" will pay ======>>>")...

Hi everyone, I got some difficulty in sorting out the below formula, it is a complex one with array. =IFERROR(INDEX(Payroll!$C$9:$C$95,SMALL(IF(ISTEXT(Payroll!$C$9:$C$95),ROW(Payroll!$C$8:$C$94),""),ROW(Payroll!C9))),"") formula return with no value (The value i am calling is text) Now what...

Hello Trying to create an achievement outcome workbook for students in a debating competition. I believe I need nested formula which produces Average, Good or Fantastic outcome based on multiple conditions. Condition #1 - a validation List of student class Levels - F1,F2,T1,T2,E1,E2,E3,M...

Please help I need formula to bring result in cell A4 based on the change condition in A1, A2 & A3 from the array B1:F10. <colgroup><col width="64" style="width:48pt" span="6"> </colgroup><tbody> A Area Source Jan Feb Mar Jan A Imp #FFFF00[/URL] , align: right"]1 2...

This is driving me nuts as it should be easy to complete Condition format but with two criteria's Highlight Rows A5:C1000 Criteria 1 =$B3 > 100000 This works fine Criteria 2 =$B3 > 50000 and < 100000 I know how to set up the condition formatting but Criteria 2 is an issue Can someone...

Hello, I did a bit of searching through the forums and I found some solutions, but not quite exactly what I was looking for as each query seems to be unique to that person or the OP was not explaining their needs properly. I am a complete novice when it comes to Macro and have only started...

Looking in column C I am using autofilter to find duplicates then print out sheet, will need to continue printing until condition not found <ActiveSheet.Range("$B$13:B" & Cells(Rows.Count, 3).End(xlUp).Row).AutoFilter Field:=2, Criteria1:="A1" ActiveWindow.SelectedSheets.PrintOut...

Hello, I am trying to figure out how to count unique values in column C (session) based on 3 conditions. <tbody> Name Course Session Status Date John Writing Skills Writing Skills - May 9 Completed 09/05/2018 Kelly Writing Skills Writing Skills - May 9 Completed 09/05/2018 Steve...

Hi Will it be possible to get the Row number of Each Date dispalyed (Between fromDate and Todate) in Few columns of a range ? My dates are displayed in column A, C, E, but in columns A, C, E there could be similar dates, Condition 1 if similar dates in same row of column A C and E then to...

Hey, The following is a Vba script that would be needing some altering so that if the value in cell B3 is greater than 21 AND it is not equal to Selection.Column then my code. If Worksheets("HSheet").Range("B3") <> Selection.Column Then The above is missing B3 is greater than 21 condition...

<tbody> A B C D E F G H I 1 Date Red Blue Red Green Blue Red Green Green 2 02 Jan 2018 x x x, y x y x 3 11 Jan 2018 x, z x 4 24 Jan 2018 z x x z y 5 04 Feb 2018 x, y 6 15 Feb 2018 z y x, z x x, y 7 07 Mar...