include

I need a query to find all records that has "does not meet the requirement:" in the Fault_Message Field...See Table below...Thanks <colgroup><col><col><col><col></colgroup><tbody> SITE_ID ACCOUNT Bill Day FAULT_MESSAGE 2 14779802 1 ICB0350:CBM3700:Service EE200 does not meet the requirement...

I'm using the following SUMIF statement: =SUMIF(G10:G22,"x",F10:F22) and it's working perfectly. Now what I need in cell U10 is a formula that will look at cell G10. If the value is "x" then U10 will display the value in cell E10 ----- AND ----- at the same time I need it to look in...

Hello, I'm needing help figuring out a way to tweak a formula that I use on a spreadsheet at work. I use the formula below to track active unique projects and it works fine as long as my only criteria is not counting blanks...

Hi All, I'm working with this code below that I've pasted into Sheet1 of my workbook: Private Sub Workbook_Expired() With ThisWorkbook.Sheets("Sheet1") If Date > (.Range("D3") + 3) Then MsgBox "This Sheet has expired!" End If End With End Sub...

Using I am Word 2016, and trying to create a mail merge a document that conditionally include another mail merge document based on a mergefield. Both top document and included document use the same excel spreadsheet for the database to do the mail merge. The field is named "Joined" and when it...

Hello all I am trying to learn Access and I would like to have a query that shows the month and year Below formula allows me to have the month but how can i include the year please IE: January - 2018 [MonthName(Month([Pay Invoice Date]))]

Hi, I'm trying to get the average of a list of data and can't seem to get the formula to work. I think I'm probably missing a syntax somewhere. =AVERAGEIF([14.03.2018.xlsx]Sheet1!$B$2:$99999,{"MrA","MrB","MrC","MrD","MrE"},[14.03.2018.xlsx]Sheet1!$D$2:$99999) I'm trying to get the average...

Hi I created a table. The formatted it to a table (Insert-->Table) then create a pivot table from that table. if I add a new row then I will see the new item after I refresh the pivot table but when I added a column, the column name is not showing under Fields List? I click on Analyze--> Change...

Hi, Please can someone help? If it is possible at all, I would like to edit this code so when it searches in the range for the largest number, it doesn't include the cell that has just been edited. Sub ShowMax(Optional ByVal Target As Range) Dim TheMax As Double TheMax =...

I have a list of part types in column E1:E57. In cell F59, I want to add up all the ones that include the word "Cover", but I don't want it to include any that contain the word "service". Like this: Sheet1 <colgroup><col style="font-weight:bold; width:30px; "><col...

This formula below is correct as it stands the Col AB range is .10 :999.99 I want to adjust this formula to include subtract 10:19.99 =SUMIFS($AD$19:$AD$99599,$AD$19:$AD$99599,">=.10",$AB$19:$AB$99599,"<=999.99") ( the sum of Col AB : Add .10 to 9.99 subtract 10 to 19.99 add 20 to...

I'm trying to do a nested IF statement but also include an IF(SEARCH) in the same formula. <tbody> A B C $15 $1000 ? $25 $100 ~$30 $75 </tbody> For example, Column A will occasionally include ~ for dollar amounts that are estimates. In Column C I'm trying to solve for the following...

Hey, I'm trying to expand on the code =REPLACE(AR5,1,FIND("-",AR5),"") into an array that can gather multiple numbers from F5:AR5. The problem is that those cells can contain other values that don't include a dash. Cells F5:AR5 can include: empty D N T DOT-1 NES-1 TYL3ES-1 FDR3 and multiple...

I am trying to automate the extraction/copying of data from a master workbook into a 'daily' workbook. The copying and pasting etc. I can do but what I would also like to include in my code is to do a Save As of my 'new' daily workbook with each days date. So today it will be called...

Good morning, I am looking for a way to change the sheet name to include the date. I can get VB to rename the worksheet with the date or with the content but I can't make it do both. for example: I have a sheet name TN_CUSTCARE. I can't seem to find a way to change the name to TN_CUSTCARE...

Folks, I am not savvy in excel and don't have the time to try to figure out some of the formulas,etc. I am looking for an excel expert that is interested in working for some side cash to help create a few excel templates that would include pivot tables etc. If you are interested, please send me...

=SUMIFS(Data!$D$2:$D$3924,Data!$A$2:$A$3924,B$2,Data!$B$2:$B$3924,$A3) i have my criterias, now on the column F of Data sheet. i want to exclude if any value of these three value 115 and 145 and XXII and in column G i want to include only if the cell starts with 6 or 5 or 7 thanks.

Good morning, I was hoping I could get some assistance with adding another argument/criteria to the highlighted portion of the formula below: =IFERROR(INDEX(INDEX('DATA'!$A$1:$AV$1000,,MATCH("Number",'DATA'!$A$1:$AV$1,0)),MATCH(0,<wbr style="font-family: arial, sans-serif; font-size...

The .Attachments.Count variable seems to include the embedded attachments in an email, such as images in the HTMLBody. Is there a way to only include actual attachments? Any help would be greatly appreciated!

I am trying to include references to cells in the body of an email. I can successfully include a reference to a certain cell but If any cell contains names, I want to include all of the names contained in column I and column J. Column I contains the first name and column j contains the last...