1. L

    Excel finance task

    Hello, I was given the following financial task in excel. To be honest i tried to solve it, but i would appreciate some help from your side in order to be sure. I would veryt gratefull if you can help me. 1. Please add a column in "Sales analysis" in order to calculate the gross profit of each...
  2. E

    Sales Overview Sheet to update all figures based on Date Selection

    Hi All, I know this is possible, but trying to figure it out is another matter. I have a Sales Table where a new row is added every time a sale is 'submitted' on another sheet. I have an Overview Sheet that automatically Totals each type of sale, product, total value, etc. This will of course...
  3. X

    How to spread a Target number into months by Historical Seasonality?

    Hi Community, I have month-wise data for the last 4 years and I have the overall year target for the current year. I am asking you to review whether my approach to dividing this target between the months is logical. Please feel free to add your approach on how to best do this. At first, I...
  4. J

    Power Pivot/DAX: Problem with Like for Like Sales Figure

    I am trying to build a DAX measure in a Power Pivot to show the Like for Like sales figure (LFL). LFL is simply a measure to show the sales if the customer also had sales during the same period last year. I can not get any figures at all for this, and this is due to the previous year not...
  5. J

    Count # of days listed for month/year

    Hi! I have column A:A as date (dd/mm/yyyy) from Sales entry*, column B:B as amount and D1 through D12 are months & years (11/2018, 12/2018, 01/2019, 02/2019....) How do I calculate the sales entry by month and year in column D? *Note: No sales entry date if the amount is 0 or store is closed...
  6. E

    Finding cash sales for specific cashier question

    Hello and thank you in advance for the help. How can I accomplish this with a formula. Here's the situation. In my spreadsheet column A shows the cashier ID and column C is supposed to show the cash sales for the cashier. Over to the right on the same spreadsheet column J shows the different...
  7. L

    Same Store Sales Analysis using Measures

    Hi everyone, I'm new to this forum but have spent a lot of time reading through other's posts, which are often very helpful. I haven't found a definitive answer to the following question and hoping you all might be able to provide some guidance. I am pretty new to Power Pivot - thank you in...
  8. L

    Power Query Transforming Column with Actual and Budget Amounts

    I have the following three columns of data in Power Query that looks like this: Category...……….Month...……..............Amount Sales...…………….Jan Actual...……………......$100 Sales...…………….Jan Budget...................$90 Sales................Feb Actual....................$200...
  9. M

    Database totals as I select filter

    Hi all, Got a quick question whether its possible to include totals in my database according to the drop-down I select. I currently have a database that have 4 different variables and another tab that brings me a P&L view using sumifs according to the chosen variables. There's a drop-down...
  10. C

    Find Values in a Column with VLOOKUPS in It

    Hi All, I have a column that has 1,000 rows in it. Each cell in the column has a VLOOKUP function in it. When I search in that column I get an error telling me it can't find what I'm looking for. For example if "Sales" was the result of one of the VLOOKUPS in the column and I do a Control F and...
  11. H

    Sum Total of Date Range in Pivot Table

    I want total sales for each sku in a specific date range. But what I get is daily sales excluding the daily sales that are not in the date range. So I then group the daily sales into years, so that I only get the total yearly sales for each item, and I get this. <colgroup><col style="width...
  12. G

    Conditional Format with Search and Days

    Hello, I'm attempting to add conditional formatting to a sheet. The Conditional Format is based on: 1) Column A contains the word "Sales" AND Column C is < 30 2) Column A does not contain the word "Sales" AND Column C is < 90 I attempted to build out the formula, but it does not work as...
  13. J

    Need a tier based commission calculating formula

    For a company, a salesperson gets paid the following way entirely in commission: 11% on all sales up to $100,000 12% on all sales $100,001 - 175,000 13% on all sales $175,001 - 250,000 14% on all sales $250,001 - 375,000 15% on all sales $375,001+
  14. T

    Excel 2010 Charts Question

    Hi, I a trying to create a 2-d column chart that has a secondary axis on the right hand side to show percentages using the data below Sales Success Rate Pre Launch 20000 15% Post Launch 30000 20% I want to see...
  15. G

    Extracting Data from a Larger Body of Data

    Hi, I have monthly sales data going back 20 years for a long list of products, arranged as: Column A: Product Codes Column B: Product Names Column C: Currency Codes of Sales (e.g. USD) Column D: Month-end Dates Column E: Monthly Sales Growth Rates Column F: Month-end Sales Values So, for...
  16. C

    Sum of Data based on today's month

    Hello Everyone, I have a row of sales data by month and I want to compare the sum of that row with the sum of another row of data from the same date range (ie: April-Sept 2019 total sales to April-Sept 2018 total sales), and then I want the formula to update the range of the sum when we record...
  17. N

    Macro to Combine Data from Different Columns

    I have a large sales data report containing severalgroups of customers. I would like to automatically generate individual usagereports (separate files so not by tab) from this large file for each groupevery month and save them separately on a shared drive. I would like to also have each...
  18. A

    Sum data range if a cell in the column is blank

    Hi I have a long list of data with 10 groups, I need to sum each group when the column next to it is blank. It works fine to me when a pivot table is used but some of the sales guys don't like it. I wonder if there is a formula or macro code I can use. An example of the data range is as...
  19. D

    Weekly Team and Individual Leaderboard

    Hello, I'm lost (per usual) and have searched long enough that I'm starting to go insane so my next step is to post my questions here. Our sales team is needing/wanting a leader board to not only monitor and display the individual sales but also the team (groups of 4 people) sales. So every...
  20. D

    Sales from days of this month vs same quantity of days same month last year.

    Hello, first of all thanks for your help. What I want to do is to compare the cumulative sales from working days since first of the month to current date vs the sales of the same quantity of working days same month last year. Lets say today is September 4, 2019 and we work from Monday to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back