Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    123

    Re: Dynamic formula based on pivot table

    Ya since im using Access to store all this data, i was able to figure out how to unpivot this data in access and create a table that i can then figure out if its a good trend or not, then bring it...
  2. Re: Calculated query column that returns true or false based on first 2 columns

    Thanks for your reply!

    That makes sense what you've outlined here, i might possibly be able to figure out something with this now.
    Agreed about the column name changing, might have to do as you...
  3. Calculated query column that returns true or false based on first 2 columns

    Hello there!

    So I'm trying to create a query in Access that will have a calculated column that compares the first 2 columns and return True if the first column number is less than the 2nd column...
  4. Replies
    2
    Views
    123

    Dynamic formula based on pivot table

    Hello there, i have kind of a perplexing question that I'm not sure which way to go about it. To set the stage:

    i have data which has calculated mean time between failures for our shop at work,...
  5. Re: Macro to delete emails from specific senders is not working

    If anyone is looking to use this, Ive compiled it into a complete working macro as it took some adjustments to get it to work, here's the full code:


    Dim oloutlook As Outlook.Application
    Dim ns...
  6. Replies
    2
    Views
    857

    Re: unpivotting a table with macro

    **Update
    Figured out what i had to change to make everything work!

    here's the code if anyone is interested:


    Option Explicit


    Sub UnPivot()
  7. Replies
    2
    Views
    857

    Re: unpivotting a table with macro

    ** Update

    ive been playing around with this, and have it doing what i need to do if the original table starts in "A1", so just looking for some macro help on how i can get this following code to...
  8. Replies
    2
    Views
    857

    unpivotting a table with macro

    Hello everyone,

    So i had been directed to this thread here:

    https://www.mrexcel.com/forum/excel-questions/783577-unpivot-table-2.html?highlight=unpivot+macro

    which has a very useful macro...
  9. Re: Dynamically unpivot data from a table to a new one

    ya so ive been playing around with it, and im getting pretty close actually! im to the point where i have the unpivot data go into a table on another page and then a pivot table from that, so i can...
  10. Replies
    16
    Views
    2,338

    Re: Unpivot a table?

    I have a question about this code that i was wondering if you could answer.

    if my data table starts in cell "C9" instead of "A1", how would this macro have to be adjusted to suit?
  11. Re: Dynamically unpivot data from a table to a new one

    So I've played around with that macro a bit, and I'm not sure if it'll accomplish what I'm looking to do. It runs well and unpivotes data like how i would want it, but it doesn't seem like there's a...
  12. Re: Dynamically unpivot data from a table to a new one

    hmm true, that's a good point. However i wont be the only one editing the table that needs to be un-pivoted, so i would have to go in after an edit and re-un-pivot.
    Yeah agreed about 2013, for a...
  13. Re: Dynamically unpivot data from a table to a new one

    Thing is we don't have powerquery on our machines at work, and multiple people have to use this file. we are running just a bone stock excel 2013
  14. Re: Dynamically unpivot data from a table to a new one

    -bump-
  15. Re: Dynamically unpivot data from a table to a new one

    -bump-
  16. Re: Dynamically unpivot data from a table to a new one

    -bump-
  17. Re: Dynamically unpivot data from a table to a new one

    -bump-
  18. Re: Dynamically unpivot data from a table to a new one

    -bump-
  19. Re: Dynamically unpivot data from a table to a new one

    -bump-
  20. Re: Dynamically unpivot data from a table to a new one

    Could this be done with a INDEX/MATCH type formula perhaps for what im trying to achieve?
    Or if there's any other way someone can think of, even if i have to change the format of my tables or...
  21. Re: Dynamically unpivot data from a table to a new one

    I think we do have MSACCESS but I've never used it, and wouldn't have a clue how to set it up for this. I would be open to the idea though and can pick things up fairly quickly if it means an...
  22. Re: Automatically insert a row if a cell is typed into?

    Yeah, that's what i enjoy about it too! I wasn't the one who wrote the VBA so im not even sure how it works, but it works very well. And with how easy it is to set up, you can set up as many as you...
  23. Dynamically unpivot data from a table to a new one

    Hello there everyone!

    I'm in a bit of a kerfuffle... and not really sure how to go about this. I've created a workbook that multiple people will be entering data into and its going to broadcast...
  24. Re: Automatically insert a row if a cell is typed into?

    Hey there, so I've found a solution to this awhile back, and forget where i got it from but here's what i use all the time for inputting data into tables. This code is also very useful because if you...
  25. Re: Grouping Columns in Pivot Table and use Timeline/Slicer to select group

    Another idea i had on this, is i could maybe just have 3 separate pivot tables that have the info.. But i think it would be a lot tidier looking to be able to have a slicer or timeline be able to...
Results 1 to 25 of 56
Page 1 of 3 1 2 3