Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    108

    Create word document from excel file

    Hi guys,

    It's been some time since I posted here (new job has been taking up a ton of time). I'm hoping someone can point me in the right direction on this.

    I've created an excel file to do...
  2. Replies
    1
    Views
    141

    Re: index match duplicates

    Bump for help - still stuck and any assistance is greatly appreciated!

    Thanks!
  3. Replies
    1
    Views
    141

    index match duplicates

    Hi all,

    I have a table that calculates various areas between two arrays and shows the smallest areas. I'm using named ranges in a table which I believe is causing some of my issues (lack of...
  4. Replies
    1
    Views
    53

    Re: average two columns using lookups

    https://www.dropbox.com/s/ddptn98no1b1kgs/TDFWorksheetTemplate.xlsx?dl=0

    That is the spreadsheet - I am trying to do the calculations on Sheet 1 (I haven't named it yet) and the data should be...
  5. Replies
    1
    Views
    53

    average two columns using lookups

    Hi all,

    First off, I feel like I'm on here all the time, but everyone is just so helpful!

    I am trying to create a column in a table that will consolidate all the key information in the rest of...
  6. Replies
    2
    Views
    118

    Re: lookup and return an array

    Worked perfectly. Thank you. I spent 2 hours online trying to figure this out through google and youtube. Should have come here first!
  7. Replies
    2
    Views
    118

    lookup and return an array

    Hi all -

    I'm trying to write a formula that will correlate two columns of data (they are equal size). I'm having trouble figuring out how to make my lookup return all the values from the column I...
  8. Replies
    13
    Views
    474

    Re: MATCH #N/A Error

    Must have been a function of me playing with the original. I pulled down the one I put in the dropbox and it worked for me. Thanks for your help guys!
  9. Replies
    13
    Views
    474

    Re: MATCH #N/A Error

    Unfortunately that doesn't work either...

    How can I correct the mismatch on the table headers?
  10. Replies
    13
    Views
    474

    Re: MATCH #N/A Error

    Sounds good to me.

    I'll wait patiently. The rest of the analysis I want to create is dependant upon being able to get something into that column. The next step would be to average out all the...
  11. Replies
    13
    Views
    474

    Re: MATCH #N/A Error

    I tried a couple of methods to get the numbers to be numbers and despite these attempts it still doesn't work. Would I be better off remaking the table and starting from scratch?
  12. Replies
    13
    Views
    474

    Re: MATCH #N/A Error

    How do I fix it so they are actually numbers and not numbers shown as text?
  13. Replies
    13
    Views
    474

    Re: MATCH #N/A Error

    https://www.dropbox.com/s/ddptn98no1b1kgs/TDFWorksheetTemplate.xlsx?dl=0

    That's the current version of the workbook.

    In the future I will use specific participant data, however, to make it work...
  14. Replies
    13
    Views
    474

    MATCH #N/A Error

    Hi all,

    I've been trying to do a two dimensional lookup in excel and am having trouble with the match formula.

    I have two columns in the main table, one which will be the row lookup in another...
  15. Replies
    4
    Views
    383

    Re: Optimal Amount of Data

    Perhaps not - I just registered for the updates... By the time it comes around, I should have a solid foundation of PowerPivot and how I want to structure the data to make it worthwhile.

    As the...
  16. Replies
    4
    Views
    383

    Re: Optimal Amount of Data

    Thanks Matt -

    Also have to say that you blew my mind by adding comparison tools for the report... with enough data on a large scale that would be extremely helpful and valuable to the process.
    ...
  17. Replies
    4
    Views
    383

    Optimal Amount of Data

    Hi All -

    I have been attempting to put together a tool and was wondering how much data and the best way to structure it for re usability.

    I have several clients and am trying to measure each...
  18. Replies
    12
    Views
    1,521

    Re: PowerPivot Help

    Matt -

    I have another question about calculated columns.

    With the data sample that I uploaded on the participant table, there are several columns that I calculate in excel. Would it be...
  19. Replies
    12
    Views
    1,521

    Re: PowerPivot Help

    I think I'm going to have to put together several different bands to make this work... This will be my project for the very slow Christmas holiday week.

    On another note - I just ordered your book...
  20. Replies
    12
    Views
    1,521

    Re: PowerPivot Help

    Matt,

    Sorry for the confusion - I'm probably not describing this correctly.

    For the first question, what I am looking to do (and have done through powerpivot) is use the age table to create...
  21. Replies
    12
    Views
    1,521

    Re: PowerPivot Help

    Matt,

    Please see below for the raw data I am looking to manipulate:
    https://www.dropbox.com/sh/z8nx1cayf63qxn9/AAB4Ndu7BMP65ZgK0tweSozia?dl=0

    I copied the tables from the existing workbooks...
  22. Replies
    12
    Views
    1,521

    Re: PowerPivot Help

    We also have a sharepoint system set up and my end goal was to have participant information stored in each company site in a sharepoint list that I can then pull from for the analysis and build as...
  23. Replies
    12
    Views
    1,521

    Re: PowerPivot Help

    Matt,

    Thanks for the offer and sorry for the delay (I was away this weekend with the wife and didn't get back until Monday night).

    What is the best way to get the files to you? The way I have...
  24. Replies
    12
    Views
    1,521

    PowerPivot Help

    Hi All,

    I am trying to create a model to evaluate participant data and then create a series of charts and tables to correlate that data output to a specific target date mutual fund series.

    I...
  25. Replies
    6
    Views
    2,417

    Re: Averageif and vlookup

    Yes, the cells are left blank. Everything is formatted as a % including the ones that are empty. Would that be the issue?

    John
Results 1 to 25 of 31
Page 1 of 2 1 2