Search:

Type: Posts; User: Matty; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.15 seconds.

  1. Replies
    1
    Views
    563

    Re: Can MDX be used for this?

    Hi,

    Update...

    I've managed to write a Calculated Measure that returns the following:


    <tbody>
    Short Month
    A
  2. Replies
    1
    Views
    563

    Can MDX be used for this?

    Hi Team,

    I have a Pivot Table report linked up to a data model held in the Power BI Service. OLAP is used for fast querying.

    I now need to present some of the data in a slightly different way...
  3. Replies
    15
    Views
    388

    Re: Formula to calculate how many weekend days

    This thread is a duplicate of the following:

    https://www.mrexcel.com/forum/excel-questions/1101892-missing-days-without-weekends.html

    treeppm - Please keep questions of the same nature within...
  4. Replies
    22
    Views
    498

    Re: Missing days with and without weekends

    Given the above example, I work out that there are 4 weekend days in that range:


    <tbody>
    Date
    Day
    Weekend Days In Date Range


    09/04/2019
  5. Replies
    9
    Views
    366

    Re: SUM and VLOOKUP (I think!)

    Excel Regional Settings mean that some symbols don't travel too well.

    Here's dazkangel's formula formatted in a way that hopefully works for you:

    ...
  6. Replies
    5
    Views
    238

    Re: Delaying production

    No problem. Glad you're sorted.

    Matty
  7. Replies
    5
    Views
    238

    Re: Delaying production

    Hi,

    Assuming your data resides in range A1:D13, try:


    =IF(ROWS(D$2:D2)<=C$2,0,INDEX(B$2:B$13,ROWS(D$2:D2)-C$2))

    In D2, copied down.

    Cheers,
  8. Re: Matching given month to a column containing the same month

    Hi, and welcome to MrExcel.

    That doesn't give us a lot to go on. Could you provide a small mock up and post it? You can use one of the HTML makers here to do that:
    ...
  9. Replies
    14
    Views
    2,519

    Re: Countif in power bi

    Hi,

    Have a look at Ken's article here:

    https://www.excelguru.ca/blog/2018/06/27/number-rows-by-group-using-power-query/

    Cheers,

    Matty
  10. Re: Expanded Table for Many To Many Relationship?

    Hi Mike,

    I suspect the only way to make this model work would be to create a single table in Power Query that brings BridgeAuthorBooks and dAuthors together so that you have one table with the...
  11. Re: Index and match vertical and horizontal data

    That is a fairly big data set for Excel to cope with.

    In the absence of a proper database, e.g. SQL Server or Access, consider using Power Query instead. You could then carry out any data...
  12. Thread: If statement

    by Matty
    Replies
    4
    Views
    187

    Re: help with If statement

    Hi,

    If O33, P33, V33 and W33 are all numeric, try:


    =IF(AND(C3<>"",Q2<>"",STDEV(O33,P33,V33,W33)=0),SUM(Q11:Q31),"ERROR")

    Else:
  13. Thread: If statement

    by Matty
    Replies
    4
    Views
    187

    Re: help with If statement

    Hi,

    What does this mean:

    "O33 needs to be equal to P33, V33 and W33"

    Is it that O33 must equal the sum of P33 + V33 + W33? Or O33 = P33 and O33 = V33 and O33 = W33?

    Matty
  14. Replies
    19
    Views
    582

    Re: How to extract specific data from a cell

    Hi,

    Can you provide a few examples - including the desired results - so that we can test options?

    Cheers,

    Matty
  15. Replies
    7
    Views
    183

    Re: How can this vlookup be achieved between 2 dates ?

    Hi,

    Given the following exists across range A1:J5:


    <thead>
    Name
    StartDate
    EndDate
  16. Re: Index and match vertical and horizontal data

    Hi,

    Below set up across A1:I7 for illustrative purposes only. Please change ranges to suit your actual data set.


    <tbody>
    productID
    18/05/2019
    17/05/2019
    16/05/2019
  17. Replies
    4
    Views
    166

    Re: 2nd Occurrence index match on dates

    Hi,

    Based on your data residing in range A1:I2, try:


    =INDEX(B1:I1,MATCH(2,1/(B2:I2<>0))+1)

    Array entered, i.e. with CTRL+SHIFT+ENTER.

    Note: This solution will always return the first...
  18. Replies
    7
    Views
    8,287

    Re: Formula to calculate forward coverage

    Welcome to Mr Excel,

    How is your data laid out? If in weekly buckets, you can just multiple the result of the formula by 7 to get days.

    Cheers,

    Matty
  19. Replies
    0
    Views
    117

    Web query error handling...

    Hi Team,

    I have the following code that returns data from the web (via Power Query):


    Application.ScreenUpdating = False
    If CheckBox1.Value = True Then
    ...
  20. Replies
    7
    Views
    267

    Re: IF Statement - Help

    Glad you're sorted.

    Note that the curly brackets {} are superfluous in the above formula - they're only needed when passing an array, i.e. more than one value.

    Matty
  21. Replies
    7
    Views
    267

    Re: IF Statement - Help

    Sounds like:


    =IF(F45=0,"",IF(D8="Company","321/783",IF(AND(D8="Partnership",F45>0),F14,IF(AND(D8="Partnership",F45<0),I14,IF(AND(OR(D8<>{"Company","Partnership"}),F45>0),"511/001","521/001")))))...
  22. Replies
    4
    Views
    317

    Re: Counting unique values

    Hi,

    I'd do something like this...

    Sheet2 (A1:D10):


    <tbody>
    IDs
    Description
  23. Replies
    7
    Views
    267

    Re: IF Statement - Help

    Hi,

    Your formula looks, syntactically, a little weird.

    Could you share a short example to illustrate what you're trying to do?

    Matty
  24. Replies
    4
    Views
    181

    Re: Trim/Substitute but.. also, replace?

    Unless I'm missing something, isn't this just:


    =SUBSTITUTE(A1,"Network Bridge","NetworkBridge")

    Matty
  25. Replies
    4
    Views
    181

    Re: Trim/Substitute but.. also, replace?

    Can you provide a couple of examples of the before and after (desired) result?

    Matty
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4