need help

  1. M

    Resize Every Table Of my Powerpoint Document

    Guys I really need some help. I have tons of tables in a powerpoint document. Some are 2 in x 2 in and some are 3.5 x 3.5 in. I need to resize only the 3.5x3.5 tables to a size of 2.8x2.8 I know this can be done with some easy vba code, but I don't possess the knowledge for it. I know it has to...
  2. S

    Sumifs

    Hello Everyone, I have following table and need help on sum total of Value 1 column. Value 1 Value 2 100.00 100.00 200.00 500.00 300.00 300.00 400.00 100.00 I am looking for a formula which would return value based on the following criteria: If Value 1 = Value 2 then exclude that...
  3. S

    Need help on Power Query to transpose data

    Hello Everyone, Need help to convert data from column wise to row wise. My current data set is as follows: Column 1 Column 2 Jan 100 Feb 200 Mar 300 April 400 May 500 I am looking for a result as follows: Jan Feb Mar April May 100 200 300 400 500 Thanks in advance. Best...
  4. P

    Power Query Loop Calculation

    Hi, I am new to Power Query and have an issue with a task which is relatively easy to complete in excel. I need to get a loop calculation where the next output is dependant on the previous output in two places. Please see below for a brief snapshot. The Starting point is 100 and no calculation...
  5. A

    Calculate KPI using percentages

    Hi Gurus I hope I can explain this correctly. I need to calculate a KPI using %, I got as far as creating the target. Column D is the target of 100%, so if the target is met then the achievement is 100%, I need to calculate the achievement with a max of 200%. Any ideas on how to get this done?
  6. S

    Need help DAX LOOKUP formula which would work like VLOOKUP

    Hello Everyone, I have two tables Table 1:- Voucher No. Invoice No. Invoice Amount Invoice Date Vendor Name 1 ABC-1 100 14/05/2019 ABC Company 1 ABC-2 200 14/05/2019 ABC Company 2 EFG-1 300 31/05/2019 EFG Company 2 EFG-2 400 31/05/2019 EFG Company 3 XYZ-1 500 30/06/2019 XYZ...
  7. S

    Need help of Date Format

    Hello Everyone, Is there a way to show a date as "MM-YYYY" format in power query or in DAX. The actual data is in "DD/MM/YYYY" format. Thanks in advance. Best Regards,
  8. S

    Copy data from two different sheets

    Hello Everyone, I have two sheets with follow data: Sheet 1 SR. No Data 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H Sheet 2 SL. No Data 1 100 2 200 3 300 4 400 5 500 6 600 7 700 8 800 I am looking for a formula/way to copy data from above sheets to a third...
  9. L

    "Translation" of Excel formula into M language for the Power Query Editor

    Hi guys, I am totally new to Power BI, the Power Query Editor and most of all the M language. I wanna try to import data from different Excel documents using the Power Query Editor and then merge different columns from these separate documents using the joins function. Finally, I plan to add...
  10. L

    Drill through y-axis on stacked column chart

    Hello, I have a stacked column chart with dates on the x-axis and different codes on the y-axis. I would like to set-up a drill through / drill down function for the codes on the y-axis but I don't know how to do this. For example, one of the stacked column is the code "3xx". This code is...
  11. J

    Need Help?? (Not sure what function to use)

    Hi, I am trying to write a formula that will tell me if a client is new or existing. Below is some sample data of the file I am working with. <colgroup><col><col><col span="25"></colgroup><tbody> Client New/Existing Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17...
  12. K

    Filter and copy table

    Hi All, I am struggling with copying over a filtered table from one workbook to another. the workbooks are both open. The table is in the commission tab in the Sales Master - 2018.xlsm file So, I need to filter the table to show all the data of the name of the person at the end of the...
  13. J

    Color of Text in Formula Bar is Black -- Need Color

    Hi all, I just upgraded to Win 10 and Excel 2016 (64 bit), was previously on Win 7 and Excel 2013. I disable "allow editing directly into cells" within the options so that all my editing is done in the formula bar. In Excel 2013, when pressing F2 to edit a formula, the font would change color...
  14. T

    Timeline Slicer - how to link it

    Hey guys, I'm totally new to Power BI and currently stucked with my work... For you it might only take a few minutes, but for me it would mean a forune! What I would like, to have a slicer that starts from "Service Created". So I only see the Services that has been created before the chosen...
  15. J

    Replacing unknown values/text in the same cell as a known word

    Hey you all, I am pretty much a newbie to the whole Excel macro area and I tried my best to Google the answer for my problem but couldn't quite find a satisfying solution to it. So what I am trying to do is to censor all names from an Excel file by replacing the very next word of "herr", and...
  16. C

    Lead Time Calculations

    I can't seem to figure out a formula for this. Please help! I want it to count business working days in numerical output for when I should Order the part based on the date I open the excel file compared to Due Date with Lead Time. <tbody> A B C Program Due Date <colgroup><col width="64"...
  17. O

    Prorating savings based on number of months in a quarter

    Hi All i need with a formula to do the following calculation 1 determine the quarter that a date falls in and then compare it to the last quarter of the year. 2. Determine the number of months in each quarter and then prorate an amount based on the number of month in each quarter. for example...
  18. F

    Count Values Greater Than Measure Average

    Hi, I have this example in my onedrive. Link: https://1drv.ms/f/s!As8YC7wZr8RKist1_Ql70SsOKar7yA I create the measure MEDIAN. I would like to count how many itens in the Subcategory column Greater Than the MEDIAN. Could this calculation be done as a measure, not column?
  19. F

    PERCENTILE.INC for each category

    Hi, Here is an example with my challenge click (onedrive files) I following cues from https://powerpivotpro.com/2011/09/creating-accurate-percentile-measures-in-dax-%E2%80%93-part-i/ and ERRATA https://powerpivotpro.com/2012/05/percentile-measures-in-dax-errata/ I am trying to get...
  20. F

    Percentile 80 in Dax (Excel 2013 Version)

    I have this sort of table below and I'd like to calculate percentile 80 to "qtd/cons" for each category in "Col1" as a calculated column. Col1 qtd cons qtd/cons <tbody style="border: 0px...

This Week's Hot Topics

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 MrExcel.com.
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 "mrexcel.com".
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
Top