sale

Hello, Looking for a formula. If For instance in a given period, total Sales went from 9 to 11. I need Sale #10 to be at 0.5 and sale #11 to be at 0.4. Last month and this month Sales are in M2 and N2 respectively If for instance, if sales went from 35-42. I need 5 sales at 0.2 and 2 sales at...

Hi can someone advise how to execute a calculation over a subset of rows only? In my case, I have a table that lists customers and their individual sales. I need a dynamic measure that loops over each customer, and adds their sales to give a total figure. Example - Customer, Sale, Total...

=IF(ISBLANK(C17),"&",IF($L$14="INTER STATE SALE",(M33))) and IF($L$14="STATE SALE",(I33+K33))

I have an excel file having nine sheets. Each sheet is having different tables. I need a macro to copy the cell values containing a particular substring and the values against those cells in the third right column and paste the same in two specific columns of excel sheet of a different excel...

Hi There, I hope someone will be able to give me some tips! I have 52 worksheets (one for each week of the year) each with about 6k lines on. Each sheet has a list of products and their sales for that week. I am trying to create one master sheet with a total sale for each product. I...

Hello, I am looking to create a formula to update a rolling inventory need. please see below - thanks for the help! Need formula for E/F/G BELOW: <tbody> A B C D e f g 1 Current Inventory Monday sale Tuesday Sale Wednesday Sale Inventory need Monday Inventory need Inventory...

I have 5 workbooks where I want to copy the data from sheets 2-5 for same row header (which are in row 4) one below the other where the row headers are the same for eg Sales Shirts must all be copied one below the other where the row header in row 4 contains the same header for eg Sale Shirts...

Hi I have a condition that either returns a profit or does not return a profit. So if there is a sale, column A = S. If there is no sale, column A = NS If there is a sale then the return (column D) is price (Column B)*quantity (number of units) (Column C) If no sale then the return is 0...

Hello , I'm trying to add codes to lines in VBA to make my sheet cleaner looking and less likely to be messed with. I'm am very new to this. I know that my range U4 has " in the formula and is causing an issue. What is the best way to solve it? Sub NewDashboardLine() ' ' NewDashboardLine...

Hi Everyone, I have searched the forums for an answer to this but to no avail. I am hoping someone may be able to help me, I have a large data of Sales amounts sorted on a daily dates....these dates look like: 12/11/2017 then 30/4/2015 etc ... I want to group the sales by month then by...

I have a cell that I need to populate with data based on the information of two different cells. To lay this out for you all: I have a sheet that is going to generate payment based on a sales person's status (Certified or Trainee), and the classification of their sale (1st, 2nd, or 3rd-level...

SALES 65000 103000 161000 CRITERIA 1 50000-99999 100000-149999 150000-199999 CRETERIA 2 12 16 24 CRETERIA 3 3% 3.5% 4% REQUIRED YOUR HELP PLEASE...

I have determined an IRR of a commercial property from its cash flows after a sale in year 10. How do i go about figuring out what portion of my IRR comes from cash flows and what portion comes from the sale of the property?

Hi, I really hope someone is able to help me out. I have been looking for ways to resolve this excel challenge :) I have an excel file with 3 worksheets (Overview, Input Data and Current Candidates on Project) Overview is simple. It shows dates for the year, and start date on the left side...

Hi guys, I'm sure this is stupidly simple, but my brain doesn't want to point me in the right direction.... I am selling products, I have my purchase cost, my sale price and I want excel to calculate the price of the product after a given % discount. At the moment, if i type in 15% into the...

Hey guys, I'm been stuck on this formula for a while, please help. The raw table below shows the fruit sale by month. Im trying to create a Month to Date formula that sums up the value of a specific fruit, based on the month selected. Specifically I can create a formula to sum Orange sale in...

Hi, I made this sample file. I would like to do the following under Nov Sales Sheet. https://docs.google.com/spreadsheets/d/1OawXSruy50khcw_zQDQtd7vhPlslpmsQUR-gUoCgrU4/edit?usp=sharing If SALE(C5) = "Y"(a drop down Y and N list), I would like to delete the contents of "SELLING FOR.(E5)" and...

Dear Experts, i have 2 sheets, in 1 sheet we have different town sale and in 2nd sheet how can i put these sale into their column. please help me in this. Sheet 1 <colgroup><col><col><col><col span="7"><col><col span="3"></colgroup><tbody> SAPCODE Code SKUName ID SKUID Opening Stock Receipt...

Hello, I am after some help, I am unable to find any examples of VBA for the task i need to automate. I need to be able to import from an existing Access data base, all the rows with a sale date within the last 30 days. ( there is a column heading "sale date") If anyone has any examples they...

Hello, I have I spreadsheet similar to this: Account Manager Person Credited for Sale Joe Smith Sally Jones John Davis John Davis Sarah Clark Sometimes who the Account Manager is matches the Person Credited for Sale...