reason

<tbody> Reason Wave Short Hem Use Blocking, Short, Sticking Hem Bloc Burn Stic 4 Hem Inc Burn 0 Short, Hem Weak Inc 3 </tbody> I want to have the "Reason" Column (approximately a few hundred rows a day) automatically populate based on the values of certain cells. I added a table...

Hello Hello... Is there a reason for this or perhaps I'm missing something in the settings?

Hi so I sue this formula below and works if 2 values are found on sheet2, but if only 1 value is found lets say in I and doesn't find value in L it returns Value. Reason why I am using =0,text is because if it finds nothing I need it to return blank rather then 0...

Hello, I am trying to get my 'TidyAll' Macro to run when a cell is changed and I am using the following code Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Target.Worksheet.Range("H5")) Is Nothing Then TidyAll End Sub It is working, although for some reason...

Good morning, i have been trying various code, and copied some i have found on the internet, but am unable to get any to work. I am trying to remove the character "/" from column i , which contains numbers in this format 111111/22/11111111///11 this was the latest attempt, is there a reason...

I added a combo box to my form. When building it, as expected, it asks to select a table, query.... I selected a query that I have in my database. But for some reason it only shows two "Available Fields". I have 5 fields in my query. Why is it only showing two as Available?

Hey all, getting N/A errors for some reason. =IF(AND(OR(J255="Closed",J255="Auto-closed"),C255=1,NETWORKDAYS(D255,O255)<=17),"OnTime",<o:p></o:p> IF(AND(OR(J255="Closed",J255="Auto-closed"),C255=2,NETWORKDAYS(D255,O255)<=17),"OnTime",<o:p></o:p>...

Hi I have created Pivot ChartS based on a pivot tables For some reason - when i do an update - the chart displays no data even though there is data in my pivot table when i recreate the pivot chart - data is there but for some reason its showing no data on my existing pivot charts Is there...

Hello Guys ! Here's what I'm trying to do. Column A is my customers record. Column B indicates whether the customer is New or not. Column D is my Unique customer extracted List. Reason why I did not put Cust C as he's not a new customer. What formula should I input in Column E to return a...

Hi Guys, I am trying to extract records for the newest date within a set of data that meets 2 criteria. I have tried this array formula below but it returns a #VALUE error. Here is the formula I have tried. For some reason it is not working and I need to understand why...

I need to find a way to clean up a project without using an addin. When I say clean up, I mean like removing empty lines etc - I also need something that could add or remove line numbers if possible. I was thinking is there something like a module or function that could perform this. The...

This is what I had in another workbook <tbody> Part Number Description RV QTY Heat Line Reason Stamp 1139395 Housing 3 Shrink 1139395 Housing 2 Slag 1138395 Cap 4 Dirt </tbody> and below that <tbody> Part Number Pin Holes Shrink Slag Cold Seam Dirt Filter 1133915 0 0 0 0...

I am switching to Win 10. Is there any reason not to go to Access 2010 as well? tia Jack

I have an excel sheet with the following layout: My goal is to find each occurrence of a machine number that has a downtime equal to or greater than 4 hours and put that info Plus the reason into a separate table. I want to search by machine number find downtime =>4 and return each occurrence of...

Task I have a commission report for my team - I've managed to get the formule correct to total each person by booking agent BUT, I need to have a check/balance......IF THE RANGE DOES NOT INCLUDE THEIR BKAGENT INFO - SUM IT So, for each employee, its BZ70XX - where XX is their individual...

I've got the following set of conditional formatting rules: Problem with that is that for some weird reason, there are fields that aren't coloured: for instance, today is 6 March 2018 and the fields for 14 March 2018 aren't colour coded. I assume the reason is that date values don't just...

Hello, so basically what I'm trying to achiveve, I barely have knowledge in Excel, but It'll make my life much easier. https://i.imgur.com/eu5vWgS.png So at the moment, there's a reason if it's blacklisted or not, the email, so if it's clean it'll just type clean. So what I'm trying to grab...

good evening all. I wonder if it is possible. I have a customer complaint sheet with a list of complaint reasons. I then fill in complaint with date, reason and various other info. at the top of the sheet I have the months of the year and I want to populate how many times during a given month...

<tbody> Hi I am trying to copy a folder from and paste it into another folder which I have created on my desktop. The creation of the folder went succesfully but copying doesn't seem to work for some reason. It keep getting the error that the filename cannot be found although the pathname is...

Hi All, I have a large data set with details from A1 to H1 containing details like Date, Time Shift, Week Number etc then from K1 to CY1 showing issues found. These cells are filled in for each product checked as a single part could have multiple issues. I am now trying to pivot this...