need help

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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"...
  8. 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...
  9. 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?
  10. 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...
  11. 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...
  12. B

    3D Map 2016 Excel

    Zip Codes, the New England section of the United States where the zips are truncated in excel like 01001 or 01002 end up in Europe after I load them into the map. I thought it was because the first zero was truncated, so I formatted cells with 0####. However this still does not work, and the...
  13. M

    Moving Data into one Row Based on ID and First Mention

    With the below spreadsheet, I am attempting to have one row per unique identifier. You can see in the 8 empty columns to the right, I need to show if and when each person first attended each of the 4 steps as shown in the Attribute column. However, since some people may have attended one of the...
  14. A

    DAX Max Month Measure

    I am new to this DAX language and I am sure the solution isa very simple one, but I would appreciate some help.<o:p></o:p> <o:p> </o:p> I have created two measures. <o:p></o:p> MAX MONTH=MONTH(MAX('MONTHLYSALES 002'[Date])) 2016 ADJ NET SALES-YTD= CALCULATE(SUM([ADJUSTED NET SALES])...
  15. Q

    How to back into a weighted average?

    <tbody> I need help calculating a weighted average rate for a specific value. I know value 226 has a weighted average of 0.33920. How would I calculate this, given the criteria below? Thanks in advance for your help, it is much appreciated. <colgroup><col width="77" style="width: 58pt...
  16. L

    Vba beginner question

    To dear all. In my vba task, I meet one question like the following. Hope someone can do me a favor. <tbody> <colgroup><col></colgroup><tbody> Random uniform 1 2 3 4 5 6 7 8 9 10 11 12 </tbody> <colgroup><col></colgroup><tbody> 0,964274899 0,038850448...
  17. smide

    Problem with VBA code which paste results in wrong Workbook

    Hello. I have a problem with code which runs periodically (every 30 seconds). Basically, the code compares data from two Sheets (at the same Workbook) and then paste data (under certain conditions) from Sheet4 to Sheet1. However, when I open some other Workbook (window on that "other"...
  18. J

    How to SUM just positive values in month x

    Hi brilliant people! I want to sum just the positive transactions in a month, my current code to sum the result of the month is =SUMPRODUCT((MONTH(Logg!$C$24:$BN$24)=C75)*(YEAR(Logg!$C$24:$BN$24)=2016)*(Logg!$C$60:$BN$60)) But i want to sum only the positive numbers, to later get an average...
  19. S

    finding the weighted average for certain groups within a large data set

    Hello all, I need to find the weighted average for multiple items within groups within a large data set and dont know if this can be done automatically. I have groups, say multiple investors for one loan and 261 loans. I need to find out the weighted average for each loan and am currently...
  20. S

    Please Help me with this VBA

    This VBA code I am using has a problem I hope someone can help me with. The code is posted below. What the code does is concatenate columns A-G into K but what makes it unique is it bolds the first sentence of each cell in the result column K and preserves the way dates are actually appearing...

Some videos you may like

This Week's Hot Topics

Top