sale

Need to deduct raw material quantity once the sale is happened for finished good. Example a cake of 1 kg will have different ingredients like sugar 20gm, baking powder 20gm, etc. So if I sell 1 kg cake automatically the ingredient should be deducted from stock. So if I have sugar say 100gm in...

Hi all, I need to solve a problem of dividing whole numbers in excel based on these variable: Company AA can only sale to company A and the quantity bought and sold is always the same. In this example 44 000. Company A1 can receive 6000 from AA1 and 9000 from AA2 or 15000 from AA1, etc. That...

Hi, i have a range of sales starting in column Q2 and I need to add a formula that will add a value based on the range of the sale. Say Q3 has a sale value of 43.00 I would want this to return Group A because its within the 0-50 range of sales for first column. The complete list would be...

Pls help I want to find the Weighted average of the following data in a single column : I have tried Sumproduct(--(Heads="Freight")*(Value),(Heads="Sale")*(Value))/Sum(Sale) COUNTY Heads Value A Sale 200 A Freight 35 A Distance 50 B...

Hi, Im wrangling a pivottable based off a single table. Its displayed in a tabular format. The table has property sale document number, price, sale date, buyer, seller, land description (e.g. Lot on Plan), certificate of title and I have got calculated fields for total area and, number of lots...

Hi I'm trying to flag data that appears since the last time the report was refreshed. For example, if the sale date was 28/07/19, flag this row as "new since last refresh", if the record wasn't present on the last report version. Any ideas please, guys? I've Googled about and looked through...

I need assistance writing a code for identifying items not being sold within the last three months. The last sale dates are in column P,Q,R This is the last sale date at each of our three locations I need to identify which rows have not had a sale in the last 3 months and copy and paste all...

Hi to all of you, kindly require to provide me support for a VBA code so that, to prepare “Sub Totals” per year base on Col. “A” but starting from “A13” till last completed row. I present below the original data and expected result. Thank you all in advance <!--[if gte mso 9]><xml>...

Good Morning I would like to combine text and formula's for example it would star Hi, and then take the info from the sale sheet by date cell B2 then continue with text blah blah blah and then insert another formula from the sale sheet by date cell H2 and then continue with text blah blah blah...

I want to write a sentence only using formulas, for instance, I am comparing many things about a home. I would like to say how things are similar, superior and inferior all in the same sentence if it applies. My version of excel is not really excel at all but a spreadsheet built into my software...

I currently have 3 different tables on one sheet. a table that lists the standings of sale execs at a certain site. another that has the standings of all the sites a final one that has the standings of all sale execs as the all sale exec table is bigger than the rest i have an auto filter code...

Hi forum, any help on this, including approaches I haven't considered, would be helpful. I scrape several websites to get raw data on foreclosure sales. One such website has changed their formatting and royally hampered my data gathering efforts. My starting sheet contains these data points...

Hi all, I'm new to Excel and totally overwhelmed trying to master it. In my spreadsheet that will keep track of my stock investments, I want Column H (total profit) to subtract $10 from every answer to factor in commission fees. My formula for Column H is: =(E3-D3)*F3-10, where E3 is my sale...

I am familiar, to an extent, with index-match and is what I am using in my spreadsheet for most of the equations. My spreadsheet is using public housing data for my local community along with manually inputed data such as what school, what neighborhood, and if it is on the water or not. Every...

I have a worksheet with columns as follows : A B C D E F item batch date qty rate amount berries p-1 11/11/2010 2300 39.59 91065.97 berries p-2 24/12/2013...

I am trying to solve for IRR. If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use? So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do...

Enter a formula in cell J4 using the IF function to it whether or not the item Beaded Earrings should go on sale. It will go on sale if its current sales rank (in cell G4) is 8th or lower. (Hint: If the cell value is greater than or equal to 8, it will go on sale.) So far I have =IF(G4>="8"...

Hi, In cell A1 I have detail like below: "Sale - I will give a towel" What I need is for an if formula to look for both terms "Sale" and Towel" in the cell, if both terms are there I need it to return "Sale1" If only "Sale" is in the cell I need it to return "Sale2" I hope this makes sense...

Me again, I have a table along the lines of: <tbody> a 1 123 b 1 34 c 1 235423 d 1 2435 a 2 214 b 3 2354 b 2 2352 </tbody> Where first column is an account number, the second is the sequence of the sale and the 3rd is the value of the sale. What I want to do is to have a...

Hi all, I'm hoping someone can help with my problem. I need a formula which can concatenate the values in a row along with its corresponding column header and sub header descriptions, I assume it might some combination of INDIRECT with Match and Concatenate but am struggling to thing of how it...