Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    218

    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?
  2. 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...
  3. 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...
  4. 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:

    =...
  5. Re: How to organise this data (Year, Vendor, expenses)

    Hi Sandy,
    How did you create your first result?

    This is how I did it, but it felt 'messy'/unorganized:
    I created a pivot table for each sheet
    Filtered to Bottom 10 for each. So now, I have...
  6. Merging two queries in Power Query: find "M00123" using lookup value of "123"

    I have a table in Sheet1 (query1) which has vendor numbers and invoice numbers
    Sheet2 (query2) is the data table and has vendor numbers, invoice numbers, amount, paid dates

    I want to load both as...
  7. Replies
    0
    Views
    52

    Not calculating in a pivot table

    I have a table of data with three columns:
    - company code
    - company name
    - sales

    When we use Pivot Tables, we would drag, say, Company Code to the rows field and Sales to the total field. But...
  8. Re: How to organise this data (Year, Vendor, expenses)

    If I wanted to find top 10 expenses for each year, which option would be the recommended one: power query or pivot tables?

    I tried pivot tables but I'm pretty sure I am not doing it very...
  9. Using IF formula to "find" 123456 in INV123456

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

    I am doing an IF formula to see if A1 equals any of the values in C1:C3

    =IF($C$1:$C$3="*"&$A$1,"Yes","No")

    When I hit F9 to evaluate...
  10. Re: Number vs text format using MATCH function

    Hi Ahoy,


    Thank you, that's exactly what I needed. I appreciate it.
  11. Number vs text format using MATCH function

    https://1drv.ms/x/s!AvjBsEPEq12ngTMpaLVtqgZcYXLI?e=Hm2JrH

    I am trying to do a Match lookup.
    The value I am looking up could be in text or number format.
    The search value can also be in text or...
  12. How to organise this data (Year, Vendor, expenses)

    https://1drv.ms/x/s!AvjBsEPEq12ngTEmm7uG4pZsIFot?e=oA9EZo

    I have three tables of information. Each table has these columns:

    - Year
    - Vendor Number
    - Expenses

    How would you arrange the info...
  13. Replies
    1
    Views
    75

    Convert PDFs into text?

    So we receive hundreds of invoices from our customers every day.
    The invoices are in pdf format but such that you can select the text and copy and paste etc
    Is there a way to convert multiple pdfs...
  14. Replies
    6
    Views
    273

    Re: Calculating (12 threads) problem

    Hi Michael,
    I suppose I could use the COUNTA function. Actually, I didn't quite think of that until now.

    Also, with regard to my Excel freezing up every now and then, I think it was a computer...
  15. Re: Copy/paste macro so that it works for active sheet

    Also, would it help things to convert the data in SecondWorkbook to a table (say, Table2)?

    FWIW the data in LastSheet of FirstWorkbook should maintain table formatting (Table1) for my formulas on...
  16. Re: Copy/paste macro so that it works for active sheet

    Hi Fluff,

    Thank you for the code, I appreciate it :)

    My sheets (Sheet1, Sheet2..) in FirstWorkbook have formulas that reference the data from LastSheet (which is where we are pasting the data)....
  17. Copy/paste macro so that it works for active sheet

    Sub TEST()
    '
    ' TEST Macro
    '
    '(Deleting whatever data is in LastSheet)

    Sheets("LastSheet").Select
    Rows("2:2").Select
    Range(Selection, Selection.End(xlDown)).Select
    ...
  18. Re: How to transpose(?) column to desired output

    Hi Peter,
    Thank you for this awesome solution, I appreciate it :)
    This is something I will be using many times a week. Simply amazing.
  19. Re: Lookup a value, if there is a corresponding text value, then...

    Thank you, that works perfectly for me.
    I was looking for the: <>0 in your formula.
  20. Re: How do I subtitute the name of a sheet with a cell number

    Thank you Dante and Peter, very happy with the solution.
    I appreciate it :)
  21. Re: Macro error when copying pasting from clipboard

    OMG I love you
    Thank you Mark!
  22. Replies
    6
    Views
    273

    Re: Calculating (12 threads) problem

    Sub APL()
    '
    ' APL Macro
    '
    Workbooks.Open "C:\Users\MSI\Downloads\Delete 5.XLSX"
    '
    Range("A1").Select
    Windows("Delete 5.XLSX").Activate
    Range("A1").Select
    Windows("02.08.2019...
  23. Replies
    6
    Views
    273

    Re: Calculating (12 threads) problem

    Hi Michael,


    CTRL + END takes me to row 99

    When I refresh the active sheet, it freezes more often than not.
    Sometimes it freezes up, sometimes it does not. This wasn't a problem until I...
  24. Re: Macro error when copying pasting from clipboard

    Hi Mark,
    https://1drv.ms/x/s!AvjBsEPEq12ngS9ITAe84IHxcI2Q?e=tWGu3b

    If I want to create the macro button in Sheet1 and convert to numbers the column K in Sheet2.
    What would the code be?

    I...
  25. Replies
    6
    Views
    273

    Calculating (12 threads) problem

    https://imgur.com/a/0AgdX6M

    This wasn't a problem but sometimes when I hit SHIFT + F9, my workbook freezes up, the fans on my computer start spinning fast and nothing really happens.

    This sheet...
Results 1 to 25 of 85
Page 1 of 4 1 2 3 4