Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Cannot see individual dates in Pivot Table (gets grouped to months automatically)

    https://1drv.ms/x/s!AvjBsEPEq12ngUXYnGLP8pykEIRq?e=f3gY9X

    How do I make this pivot table show the dates instead of grouping automatically to year and months?

    I tried the Alt + D + P option, but...
  2. Cannot filter by months in Pivot Table

    https://1drv.ms/x/s!AvjBsEPEq12ngURD4J_Yxbfrn7OV?e=ln2Olm

    I have a sheet of data.
    I converted it to a table. Loaded it into Power Query, unpivoted the dates columns, and then created a pivot...
  3. Replies
    1
    Views
    53

    How to change "dates" to clean data

    https://1drv.ms/x/s!AvjBsEPEq12ngUI4aV0PG-l-4gVM?e=pByejI

    How do I convert the data in A1:B7 to the output in rows 12 and below (happy to use any method, pivot tables, power query etc)

    (Purpose...
  4. Re: SUMIFS and IF formula for this problem?

    So that, for example, I can use formulas to then sum totals for, say, Jan to Mar or Jan to May..
  5. SUMIFS and IF formula for this problem?

    https://1drv.ms/x/s!AvjBsEPEq12ngUHobzEXQ8yvas2e?e=Otrz6s

    I wish to unpivot the data but how would you convert the row of 2019.01, 2019.02 etc into dates?

    (Using Power Query)
  6. Re: Copy paste formulas to new sheet (absolute references)

    Ah I see, okay that's a good idea.
    Thank you Trebor
  7. Re: Copy paste formulas to new sheet (absolute references)

    My cell references are already absolute references.
    So when I copy and paste them to a different sheet, it references the new sheet and not the original sheet.

    Is there a way around this so that...
  8. Copy paste formulas to new sheet (absolute references)

    https://1drv.ms/x/s!AvjBsEPEq12ngUDMrgxRZFuYzsgm?e=ghaRAa

    Hi guys,

    I need to copy/paste cells M1:V14 to Sheet2 but have the absolute references point to the cells from the original sheet

    Is...
  9. Re: SUMIFS multiple criteria cannot reference to a cell?

    Thank you Nishant and Steve
    Exactly what I was looking for :)
  10. SUMIFS multiple criteria cannot reference to a cell?

    https://1drv.ms/x/s!AvjBsEPEq12ngTWjooUrD2AsRCFa?e=BpSibC

    I am trying to do a SUMIFS formula calculating the sales column if the country equals australia, india and china (actual data has more...
  11. Re: Help with dynamic (?) formula for adding values

    Actually, I figured it out
    I just used <= in the criteria

    :)
  12. Help with dynamic (?) formula for adding values

    https://1drv.ms/x/s!AvjBsEPEq12ngT4paIVYB5-Ol3Y2?e=XitD7z

    Hi guys,

    I have monthly revenue data that I want to add (YTD figure)

    Need a formula whose output updates based on say if I choose...
  13. SUMIFS formula picking up all values instead of criteria

    https://1drv.ms/x/s!AvjBsEPEq12ngT3R9p-e8rqgVZkN?e=k7e4yd

    I have two columns.
    First column =age of invoice
    Second column = $

    I want to do SUMIFS for invoices > 365 days

    E6 works fine for...
  14. Re: How to get my formula to produce a cell reference

    Ok I think I did it but I need to be able to link it to a cell in another sheet. My formula:

    =(INDIRECT("A"&(MATCH('Summary by region'!A62,'PV Vol'!A:A,0)-1),1))

    The above formula finds A7 in...
  15. How to get my formula to produce a cell reference

    Cell B1 in Sheet 3

    =A(MATCH('Sheet1'!A55,'Sheet2'!A1:A28,0))

    Suppose the MATCH formula produces the number 8
    How do I make it so that the whole formula points to cell A8

    Want to be able to...
  16. Power Query - Filter Table Based on Distinct Conditions from List

    https://www.youtube.com/watch?v=fRd6wYkfDUQ

    In this video, Mike uses a list to extract rows from the Start table that DO NOT include anything from the list.

    Is the opposite possible?
    If it's...
  17. Replies
    2
    Views
    105

    Re: How to fix these dates?

    I uploaded the spreadsheet again.

    A2:A6 shows dates in MM/DD/YYYY format
    A7:A9 is in DD/MM/YYYY format but Excel doesn't recognize them as dates.

    When I sort, this is the output.
    Looking for...
  18. Replies
    3
    Views
    132

    Re: How to group this in Pivot Tables

    Beautiful. Thank you Sandy, I appreciate it :)
  19. Replies
    2
    Views
    105

    How to fix these dates?

    https://1drv.ms/x/s!AvjBsEPEq12ngTwwKMwIFJo5_Tk7?e=J87rl6


    How best could I go about fixing this column so that it shows dates.
    The bottom half is in text format.
    Thanks all.
  20. Replies
    0
    Views
    49

    Adding cells in Pivot Table

    https://1drv.ms/x/s!AvjBsEPEq12ngTsi8XTPb5NMJ1_h?e=YIGtSL

    I wish to add the total for B and C in the Pivot Table like in cell D6.

    Suppose I update my PV and more data is added.

    How do I make...
  21. Replies
    3
    Views
    132

    How to group this in Pivot Tables

    https://1drv.ms/x/s!AvjBsEPEq12ngTpjIV0Ri5AcMKZa?e=0sU8cn

    I have a table of data.
    First column = company names.
    Other columns = invoice amount aging by days
    E.g. column B = 1 - 010 means...
  22. Replies
    1
    Views
    526

    Is this merge possible in PQ?

    Hey folks,
    Suppose I create two queries for the two tables in my spreadsheet
    https://1drv.ms/x/s!AvjBsEPEq12ngTmYWfZW_bAjU4w7?e=9d2PBI

    Is it possible to somehow merge them as per my example?
  23. Re: Merging two queries in Power Query: find "M00123" using lookup value of "123"

    It is what I want but I'm trying to understand the functions. You combined several functions into one applied step. That's great, but as a beginner, kinda hard to learn from it and apply it/practise...
  24. Re: How to organise this data (Year, Vendor, expenses)

    No, I mean how did you get your output in your post 4 .
    What you described is for post 5 , which shows top/bottom 10 vendors filtered by grand total.

    Your output in post 4 shows top/bottom 10...
  25. Re: Merging two queries in Power Query: find "M00123" using lookup value of "123"

    Have updated workbook in the link with Sandy's code

    In the Merge query, the last Applied Step has the below code:

    =...
Results 1 to 25 of 106
Page 1 of 5 1 2 3 4