loss

Hi, I have an optimization problem, that I'm trying to solve in Excel, but it keeps getting too complex (too many columns/iterations), and I hope someone in the forum may be able to give some pointers. On a given day, at a given timeslot, I have 6 production lines, each with different...

Hello All, I have the following formula: =SUMPRODUCT(--SUBTOTAL(3,OFFSET(Audit!$F$2:$F$57,ROW(Audit!$F$2:$F$57)-MIN(ROW(Audit!$F$2:$F$57)),,1)),--(LEFT(Audit!$A$2:$A$57,(FIND("-",Audit!$A$2:$A$57))-1)=F$11)) The formula does do what is intended, but I would like to use this formula in other...

I feel like that's a weird subject but here's what I'm trying to do. I've analyzed year over year sales by customer and identified when a customer was new, if they were an existing customer but their total sales increased, decreased or stayed flat YoY, or if they were lost. (None would indicate...

Morning , I have the following formula within a cell that is formatted as % =1-(AA63/T63) Until I populate the cells included in the formula I returns div error (as you would expect) I am at a loss as to how I can "if error" this formula , can someone kindly help me out ? Thanks Russ.

Hello, I have been working on a project where I have one file querying data from a set of other files, all found in one folder. I've gotten the query to function as expected, however I have seen a pattern of data from the source files being lost. I don't know if this is an issue in the files...

Good Morning All, I am trying to format a sheet I have for the football team I run. I have a score sheet and want to automatically pull data from it using W,L D (Win, Loss, Draw) this data is in E21, so that I can automatically make a table showing the results. I have used the formula below...

This is my first post on MrExcel and I really need a hand... I have a multi team game log where the dates are out of order and the data doesn't contain who played who so each team must be handled independently. I'm trying to figure out win streaks and current streaks "for each" team (Should I be...

Hello Everyone I am very new to VBA so i am at a loss with this code i have tried copying existing codes from other posts but havent had any luck as yet. The workbook is essentially a price book and i am trying to create a macro that will copy the text from the woksheet "flexible duct" to the...

Hi wonderful people, I'm working on a spreadsheet for a weight loss program where a participant receives a financial reward for every full pound of weight they lose. Not sure if that title is exactly what I'm looking for, but it was a struggle to describe it in a few short words. I am...

I would like to transpose columns to rows Please note that the spreadsheet is quite large. Current file layout example: <colgroup><col style="mso-width-source:userset;mso-width-alt:3035;width:62pt" width="83"> <col style="mso-width-source:userset;mso-width-alt:5668;width:116pt" width="155">...

Hello Everyone, Hope everyone is having a good Tuesday. I am unsure of how to formulate this code. If someone could help me in the right direction that would be greatly appreciated! I have two sheets, 1 is Control Panel Size and the other is VFD Cabinet which the final answer will be copied...

Hi, I am trying to find the win and loss streaks for set of games to find out whether both teams have scored in match and if so carry it on as a streak. Thank you

I am currently working on an issue where **=IF(I34>0,IF(SUM(I34,I36)>0,SUM(E38,I38),""),"")** If the number is greater than 15 a number is shown as long as a number is in either E34 and I34 or E34 and I34/I36 Or E34 and I36 I am at a loss of the I36 peice how to get that value shown

<tbody> <tbody> RED CONFERENCE SEASON TOTAL WIN LOSS WIN LOSS 1 2 3 4 5 6 7 1 Richards 2 0 2 0 1 7 6 5 4 3 2 1 2 Argo 1 0 2 0 2 6.5 5.5 4.5 3.5 2.5 1.5 2 Shepard 1 0 2 0 3 6 5 4 3 2 2 Evergreen Park 1 1 1 1 4 5.5 4.5 3.5 2.5 2 Reavis 1 1 1 1 5 5 4 3 6...

Hi all, I would like to create a VBA code in excel 2016, so that to run through col. "AK" and where find the text "NET PROFIT / LOSS" should enter below after a blank row the below note: "Note: The above Net Profit & Loss arises, thereafter we entered the accounts dividends received, banks...

I have a spreadsheet with various columns with losses and loss dates for each loss. The problem is the loss dates generally correspond to a policy year. However the spreadsheet doesn't include a policy year so I create a column for the policy year. The losses could range over a ten year...

I have a Status Column (Win, Loss and Open), it's 6th on the Rows area of my pivot table. I want to subtotal Win, Loss and Open and show it on the bottom of the table, like how Grand Total is shown. Is it possible? What's the workaround?

To all those who have helped me in the past with the excel sheet I'm making, thank you. I just made a few tweaks to make my other tables work better so some of the stuff you showed me dose not work. This is my standings sheet <colgroup><col width="70" style="width: 53pt; mso-width-source...

need formula Philadelphia Contributionship for the Insurance of Houses from Loss by Fire W4Z6QA69 Comprehensive Insurance CI25874567 4000 1 Year were find and put dildimeter like ^ before ^W4Z6QA69 Philadelphia Contributionship for the Insurance of Houses from Loss by Fire ^W4Z6QA69...

Hi, This is a two part question: 1) I want to be able to calculate a cumulative (running) percentage of growth/loss between the current date and the first date. The formula I'm using (=D85*(365/A86-A2, where D85=39.48, A86=Today(), and A2=1.1.17) is yielding an incorrect response of 3958.85%...