unit

Hello, I have a report (shown below) for auditing pay periods and the date a lesson was graded. In column D the first entry is 9/19/2019 (in red). Based on a date in column D, I need to key in the appropriate start date (column F) and end date (column G) for the value in column D. This is...

Okay guys, I did ask this question in many forums but did not get any reply. I have a salary sheet, where new data inserted every month. This is not a one time job, it needs to be done every month. Salary Sheet looks like this. (image 1) I want to print Salary sheet for each UNIT, with total...

I have provided this request before. Tables were not visible in that thread. So creating a new one. Can someone help me with creating excel macro for the following. Data will be entered in the "Main" Table in Worksheet 1 (Main Worksheet). Shown entries for a project with two units - Unit 1 and...

Can someone help me with creating excel macro for the following. Data will be entered in the "Main" Worksheet Table. Shown entries for a project with two units - Unit 1 and 2. this could be multiple units. <tbody> Project Name "Enter Project Name Here" Test Date "Enter Test Date here"...

Hi everyone, Appreciate if you can advise the formula that is applicable for this scenario. 1. Sheet 1 - table 1 This table shows the price of apples at different minimum order qty (MOQ) in Q2 <tbody> Types of apple MOQ 1 Unit price 1 MOQ 2 Unit price 2 MOQ 3 Unit price 3 Apple 1 500...

I have a sheet with a table listing each train we have based on the unit number, e.g.: <tbody> Start End Class Vehicles Seats 101000 101999 101 2 40 108000 108999 108 3 60 </tbody> I also have another table with the diagrams and which unit is booked to work each diagram, e.g. : <tbody>...

I have a report that I receive weekly Column A will always be Region Column B will always be Color Columns C through Z may change, the order may change, a column that had activity the prior week might not exist because their is no activity. The headers in Column C through Z are known to me...

I have two columns One has Part Numbers (There are Duplicates) Second has Unit Prices I want to see the Average Unit Price when I filter. I cant use countif/SumIf.... I want to be able to filter on both columns so doing CountIf/SumIf by part number doesn't help me in this situation. I am...

Hi there, I have a huge data set (10 units and 5 years data set) that contains for each unit an indicator whether a unit is fully or partially operational or zero if not in operation. I am interested to know the number of blocks (a block is defined as a sequence of fully or partially...

Hi Experts, Following is the data and I want to concatenate the numbers with unit. The data is extracted from (=SUMIFS()). <colgroup><col span="2"><col><col></colgroup><tbody> A B 1 Quantity Formula Enetered Unit 2 1219 =SUMIFS(F42:F71,G42:G71,"PCS") PCS 3 1377...

Hello Friends, Here is a sample data which will be not more than 5 rows Col A Col B PO # UNIT 316543 Sets 316546 Pcs 316547 Sets 316548 Pairs 316549 Dozens The formula should sort values in Col A based on Units in Col B Formula should look first at Sets than...

Dear Friend ! I have a char and i want to find barcode of each Article, As you can see in my exel table , many article have same article number , name , and Unit but they have many different barcode number because their unit is not same . The problem is when i use vlookup or Index & match...

Hi All, I have three columns. Column A - ID , Column B - Price and Column C = Variation In Price. I need to first filter column A for one ID, then apply the formula in the second visible cell in Column C not counting the header - =IF(1-(B3/$B$2)=0,"OK",-1*(1-(B3/$B$2))) and drag this formula...

I get a daily report of projects that I work on showing their status. A while ago, I created a macro that cleans up the formatting a bit and makes it more presentable. It works okay; but, each day the number of projects is different or a different sheet has a different number of rows. The macro...

I have a Programme Roadmap table with the following: Column B (row 4) - Business Unit Column C (row 4) - Business Area Column D (row 4) - Technology Columns E to AZ (row 5) are week ending dates The cell values are as follows: 1. GL (Go-live) 2. PLT-C (Pilot Complete) 3. REQ-C (Requirements...

Hello, I need to calculate time based on a measured output in a table. Basically I'm try to generate a standard amount of time per output. The rules are: 0 to 1 is 20 minutes flat (even if 0.1 is delivered or 0.9 it's still 20 minutes) and every unit after that is 10 minutes per unit (if 2.3...

I have a measure that I *think* is returning what I want it to, but it's cumbersome and I'm wondering if there's a cleaner way to do this. First, here's the measure: Count of UoM Errors:= SUMX ( SUMMARIZE ( 'Match Exception', 'Match Exception'[ME_Key] ), CALCULATE ( MAXX (...

Hi guys, I am running a table to estimate the amount of sales I can generate. <tbody> Jan Feb Mar Apr May June Unit Sold in current month 10 12 14 16 18 20 Unit Sold from previous months X Unit Price ($) 4 4 4 4 4 4 </tbody> The 2nd row is where I am struggling. I am looking...

I have the range A1:A31 (for the days of the month). I have equipment that I rent out and the unit number will be entered in one of those cells, whichever day it was sent out. I'd like to be able to select another cell in that range and copy that unit number to the cell I selected. For...

I have a client name in 3 or 4 rows. Each row has a different service with different units and unit price. I want to have each client have one row, and the service hours and price in different columns. Example Smith 3 units $5.00 per unit Smith 4 units $3.23 per unit I want Smith 3 $5.00...