unit

<tbody> column/row A B C D 1 Item Unit or pallet unit per case Total Case 2 Apple 50 2 25 (=50/2) 3 Apple on a pallet 4 2 8 (=4*2) 4 Orange 8 4 2 (=8/4) 5 Orange on a pallet 15 4 60 (=15*4) </tbody> I want to use if formula to calculate for column D. what should the formula be? I...

From the following example data set I would like to count the number of rows where "Company A" and the word "Completed" appear but not counting duplicate values in the first column and ignoring the blanks that might appear in the first column. It is ignoring the blanks I am having difficulties...

Hello Everyone. I am currently working on a project for a class, the instructions and data set are below. I know I can do this, albeit it manual, without using solver I am trying to use it. Can someone please provide some guidance if solver is the correct path forward or any other way. I...

Hello, I am using below formula in order to get the data from PIVOT but the thing is it is getting more bigger and bigger as I have to add the numbers of all the months. Can someone please suggest a smart way of doing so? =IFERROR(SUM(GETPIVOTDATA(T(P$6),Pivot_EBTDA!$B$5,"Substream Leader...

Good evening, I am having (a lot of) trouble attempting to put together a formula that properly calculates my organization's tiered bonus formula. Our managers are paid bonuses according to the following criteria: Goal: "X" units rented First Tier: 0-49.99% of goal reached, $0 (if you don't...

Hi all, I tried looking for an answer myself (or here), but I just can't get it to work. Hopefully the answer is understandeable for a non-IT guy (finance background)... :-) So the problem: We have about 100 employees working on our payroll and we want to allocate their individual cost to...

Hello All, I am working on a new project and I have hit a road block. I have searched the interwebs for a solution to my problem but was unable to find a solution I could cater to my issue. My Problem I have a List Column A ("A1:A64") of Unit numbers and in Column B a corresponding list...

Hi, Apologies if this is the incorrect forum. I'm trying to add bounds and units to the category axis of a pivotchart populated with a series of dates. The Format Axis dialogue recognises that the Axis Type is a date but no Bounds or Units boxes are shown. This only seems to occur if the dates...

My apologies for the drawn out post. I receive a workbook with statistics for three different departments, two sheets per department for a total of six sheets. I copy the stats from these sheets into a larger report file and would like to automate this part of the process as this is the only...

Hi, I would like to build simple excel file to be like POS in small Market. Attached is my file. In sheet1 there is barcode, products, price, Quantity and so on..The idea is that in sheet2, to the column A will be intered products barcode from scanner, and the other dates(product name, price...

Hi: I have a pivot table set up to display unit price, quantity and totals. I want to show single unit price but Excel is displaying sum of unit price. Data is set up as: Full - 23.50(unit) 52(quantity) and 150 (total) Full - 46.00 Excel is displaying unit price as $69.50 but i want to...

In A1 I will input number of items say 30 or whatever. Then A2 will contain target price Inside A4 I have a unit price of items. Then A5 contains a different unit price for same items. Now I want a way to add different combinations of the two unit prices to give me my target price. And I...

<colgroup><col><col></colgroup><tbody> TENANT & UNIT # Total SF Buckhorn Material Handling 21,148 Unit: # 55 W - A Lease Start 11/1/1986 Lease End 3/31/2019 </tbody> Hi everyone, Does anyone know a way to lookup in the same column? I need to return the Name, unit...

Hi, i am a very happy user of Powerpivot, but i have one question: I use the Calculated field in Excel to for example calculate the price per unit, by dividing the total costs with the number of units. If calculate this division with a column in the Table, it will not give a correct result, as...

Hello Everyone, First time poster, the following query works just fine in access: However, when I try to connect it to VBA it doesn't work: I get a runtime error '2147217887 (80040e21)': Automation Error Code and query below Select a.str, a.name, b.dpt, c.desc, sum(b.[Sales TY]) AS...

Hello Everyone, First time poster, the following query works just fine in access: However, when I try to connect it to VBA it doesn't work: I get a runtime error '2147217887 (80040e21)': Automation Error Code and query below Select a.str, a.name, b.dpt, c.desc, sum(b.[Sales TY]) AS [Sales...

Hi everyone, I am working on a project that requires me to expand the acronym in column A of excel and copy the expanded term to column B. The acronyms i am working on mainly revolves around the engineering mechanical side. An example would be: Column A Column B AHU-L8-01...

Hi all, I need to be able to count the number of "yes" entries in a cell based on whether another cell contains a specific text. Here's my scenario: I have a tab called raw data that contains columns called: ID#, Title, Internal, Name, Location, Unit I want to count the number of "yes"...

Hi I want to change a cell width in vba. So I wrote the code below. I also went to option-->advance-->display-->ruler and change the unit to centimeters. I selected cell A1 and then went to home-->format-->cell width and it gave me 8.35. My questions: 1) why excel did not show measurement unit...

Hi, new to the site. Am trying to name ranges through VBA. I have four columns. In row A would be the name I want to assign to the four different ranges I want the name to be assigned to all of column A and all of Column B etc. through Column D. For example..Cell A1 is titled "Unit and as such...