coming

Hi all Does anyone have an ideas of when the new array formulas are coming to excel O365? They were released to insiders exactly one year ago now but still no sign for normal users. Apologies if there is already a thread on this, I I did a quick search but couldn't find Thanks Joe

I'm having a heck of a time figuring out a statement.... I need to know: if cell B4 is a NO, then 0 if cell B4 is a YES and cell C4 is a YES, then 10 if cell b4 is a YES and cell C4 is a NO, then 5 This is what I have, but it's coming up false...

Hi, I have 4 values of amounts , 2 values are positive and remain two are negative. value of positive and negative amounts are same (below table). when i have sum all of these 4 value then the result should be 0 but there is some other value is coming out. Please help me to coming out from...

Morning all I'm struggling with coming up with a formula to count the number of managers in a list. I have a dataset that includes week numbers, regions, deals and managers. I need to come up with a count of managers for a specific week and region. I keep coming back with the overall count, I...

Hi, I'm trying to use a Vlookup to use different ranges within an existing Vlookup depending on what's in column B. =VLOOKUP(A2,VLOOKUP(B2,StaticData!$A$2:$X$21,24,FALSE),2,FALSE) I'm getting an #value because the range is coming back with speech marks around it... Any help appreciated...

Hi I have this formula which i am using to find the number of days difference between from two dates DATEDIF(F5,P5,"D") when the two dates are the same it is coming back with 0, how do i change this formula so when the dates are the same it brings back 1? Thank you

Afternoon, I have recorded the following Macro on Excel, All i am trying to do is delete all the unwanted info from the reports i download from the system at work and have it set up to how i want it at the hit of the button. I keep getting a debug message with the activesheet.Paste being...

I have enabled Interactive calculations in Option/Formulas. I have PW protected the Workbook and the sheet. Others use the form to input data. The enabled Interactive calculations keeps coming unchecked or going back to what is default. How do I stop this from happening?

I am trying to figure out how to create an IF FORMULA in cell M3... based on following criteria, if cell H3 = “A” then enter formula J3+K3. If cell H3 = “S” then enter formula I3+K3. Been trying but coming up with #name Any hints would greatly be appreciated Thanks Bill

Hi If I have two dates in text format (20180329and 20180424) how can I work out the number of days between them? I need this to be in VBA as the two datesare coming from Access forms. Subtracting only works for dates in the samemonth. Can I convert them into dates in VBA and then use a DATEIFF?

Hi, I am looking to bring data over from one sheet to another when it matches a certain value on the first sheet. The current formula I am using is...

hi there I'm trying with coming up with VBA to select the last range I googled and this selects all ranges starting from A2 Range("A2:F" & ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row).Select The problem is I need that A2 to change dynamically. hope my explanation is ok james

Hi- I inherited a form that includes a drop down list that needs editing, I do not know where the Source of the drop down list is coming from. Is there a way i can still edit the drop down list? Thank you in advance.

Umm, I forgot why this snippet works...it finds unique values within a selection. I paste only the portion here to make a point. It transposes data in cell Cells(j, 122), Cells(j, 122) Dim V As Variant, Data As Variant Data = Selection With CreateObject("Scripting.Dictionary") For Each V...

I am trying to use the count if function and I am running into a bit of an issue. Just for example I want to count the number of cells that contain the text "1h", so I type the formula =countif(P9:P13,"*1h*") The answer I am looking for should be 1, but it's coming back as 2. It's counting one...

<colgroup><col><col><col span="2"><col></colgroup><tbody> C D E F G Formula use Date2 Weekday Time In Time Out Status 21-Oct-17 Saturday 9:00:00 14:00:00 Present =IF(D3="","",IF(D3="Sunday","Off Day",IF(E3="","Absent",IF(F3="","Absent",IF(D3="Saturday",(IF(F3<TIME(14,0,0),"Early...

<tbody> Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Late Coming Required Answer 0 1...

<tbody> A1 A2 A3 A4 A5 Name Day Time In Time Out Attendance Usman Saturay 9:00:59 14:00:59 Present Sunday off Day off Day Present Monday 7:30:59 15:30:59 Present Tuesday 7:31:00 15:30:59 Late coming </tbody> if A2 Saturday and A3 <=9:00:59, A4>=14:00:00 than A5, "Present"...

in excel one column contains like below 1 2 5 6 1 2 5 6 3 4 Now i want to find out consecutive 1 2 coming 2 times. 5,6 coming 2 times. 3,4 coming 1 time. Please let me know how this can be achieve...

<tbody> A B C D Day Time In Time Out Remarks Formula Friday 7:50:01 14:30:35 Present =IF(A3="Saturday",(IF(B3>=TIME(9,0,59),"Late Coming","Present")),(IF(B3>=TIME(7,50,59),"Late Coming","Present"))) Saturday 9:02:01 14:00:45 Late Coming <tbody>...