prod

Hi, The below table represents what I am currently doing manually but would am trying to come up with a formula to do for me. Or, some combination of formulas to get to the result I need. I need to write the result in the HTML column Currently I'm using the concatenation formula in the...

Hi All, I have the following formula that i wanted to total up where items in Col E match items in Col F and give me back a total. =SUMPRODUCT(--('Pending Prod Orders'!E:E='Pending Prod Orders'!F:F)) For some reason its counting all the blank cells that are contained in these columns which...

I work for a company that packages numerous products with different brand names. Sometimes we package the same product under a different brand name but the Lot number, expiration date, and product code are still the same. Because of us packaging product this way, this is considered a split lot...

Hey all, I have a set of data I'm trying to calculate the cost / time per completed project. A completed project is one that has gone to "Prod". (production). I want to figure out a formula that takes the below data and calculates for me the COST (or time) spent on projects that are complete...

Greetings all; I have a find last column to begin pasting data in Col A:X (returned row) The code is used earlier in the same procedure with no issue When I use the code a second time it errors out at Cell.Select Data is already in All Orgs Prod.xlsx A2:A;500 Here is the code for the first...

Hi , So I created an automated summary sheet which extracts data from multiple sheets and puts it in one workbook. I need to do conditional formatting on the data in summary sheet based on certain parameters Base Upper Lower PROD A PROD B PROD C PROD D PROD E 2 4 5 6.1 6.3...

I'm populating some files to import into another system Here's the code so far. This is part of a bigger piece of coding If Sheets("Nom Prod Dim Tag Legs").Range("A" & Rows.Count).End(xlUp).Row > 2 Then _ Sheets("Nom Prod Dim Tag Legs").Range("A3:A" & Sheets("Nom Prod Dim Tag...

I have a data set as the below simple example which is product code sales value for year <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Yr 1 Sales Yr 2 Sales Yr 2 Cum Cumulative % Prod A 35 50 50 36% Prod B 55 40 90 64%...

Hey evryone, I have question regarding following issue. My pivot table looks like this: <tbody> Month Asset Order Sub parcel for order Occupation of asset Occupation for one order Month sum Jan S2 A prod A 21:30h 21:30h ??? Jan S2 A prod B 21:30h 0 ??? Jan S2 B prod A 10:03h 10:03h...

Hi everyone, I am new here as a member and hope you will be able to help. I am trying to upload some data in a CSV to an online system which requires that each record is on a different line, but the data I have been given is all on one line, let me try to explain. This is the data I have...