• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. P

    List names using multiple Criteria from dependent drop down

    I will be creating additional dashboards for averages and summaries with the data hence wanted a INDEX List formula
  2. P

    List names using multiple Criteria from dependent drop down

    Does anyone have a formula I can use that will be able to pull values based on multiple drop downs? My data is over 2000000 lines- I am trying to create a summary sheet where we use the drop down to summarize by region travel expenses on a monthly basis. Im trying not to use a Pivot I am...
  3. P

    Macro for Multiple workbooks with multiple sheets

    Quick question: Could you explain to me how this works: F = Dir(Me.Path & "\*data.xlsx") Error: Invalid use of Me Keyword
  4. P

    Macro for Multiple workbooks with multiple sheets

    Hi, I have multiple workbooks (for each month) that has multiple sheets (for each region by MDT and QTD). All saved in the same folder I would like a macros to pull the data from each workbook (MTD tabs) and populate my master workbook as a trend summary My Master workbook has 3 tabs (one for...
  5. P

    Using drop down options to pull data

    Creating a summary tab that pulls data using the drop down options. I have historical data that I would like to summarize using drop down options. I want to be able to select a region and customer typ and have the top 3 customers for that region and specific customer type pull. Please see...
  6. P

    Need help--Drop down filter

    Yes, This worked.. Thanks
  7. P

    Need help--Drop down filter

    Hi, If I create a drop down option, I would like the next drop down to filter by the certain groups within that option that I first selected, so if there is no information on a particular field the field doesn't show up in the second drop down. Attached is the spreadsheet- I want to be able to...
  8. P

    Macro or VBA to populate a master sheet

    Hi, I have over 200 workbooks / similar templates that I need data from to populate into a summary sheet. So I need Cell C6 From referenced worksheets to populate. Does ayone have a macro to do so? All the workbooks are labeled e.g 1-Jan/Store 1 1-Jan/Store 3 2- Feb/Store 10 2- Feb/Store 2...
  9. P

    YTD calculation based on different tiers

    Hi, I need help in creating a formula for the below situation. Each region( about 30) in the report I am trying to create has different levels so if YTD amounts get to a certain level an additional amount is added..if it moves onto the next level the difference between the previous level and the...
  10. P

    Forecasting (IF Function) ....Help

    Thanks guys,... both worked :)... you guys are great!!
  11. P

    Forecasting (IF Function) ....Help

    Hi, Does anyone have an idea how I could go about the below scenerio i have an assumption page.. of which I want to be able to input a predicted termination/closure .. by doing so ( entering the year, month and employee #).. a formula that I can use in all my data tables ( be it sales...
  12. P

    SUMIF when you have a range

    Perfect-- worked great :)... Thank you for your help
  13. P

    SUMIF when you have a range

    Thanks .... This would make sense if my array matched.. but I have over 700 rows of data so my rows and column do not match, hence I dont think I can use MMULT function.. ( or can I?)
  14. P

    SUMIF when you have a range

    Please see attached I have revised it.... the highlighted I what I was trying to create a formula for. The reason is that I have over 6 years of data side by side.. and the results less the term is what is going to drive the next phase of the model am building. Thanks for your help
  15. P

    SUMIF when you have a range

    Am sorry... I should have been more clear... the 1st formula worked but it gave me the count.. what I need by month is the amount not count by month for only active employees for the year. So Feb total should be less any term for the year, march the same thing and so on so forth. please advice..
  16. P

    SUMIF when you have a range

    Thanks for your help... question though.. if I needed the total amount and not count how would I do that..?
  17. P

    SUMIF when you have a range

    Hi, I have 2 tables- one that has the key ( tells us if an employee is term and active) and this drives the calculation table to give me the amount per month. What I need is a formula by each month that will only give me the active employees of that year. So for example in the month of Feb--...
  18. P

    financial model- creating assumptions

    worked perfectly... Thank you :)
  19. P

    financial model- creating assumptions

    Hi, Does anyone know a way I can change the current formula to make it more of a "variable". What I mean.. Am working on a new store model, and I am assuming that new stores will be opened on specific months.. as we forecast out this months can change.. I want my formula to 1) change the amount...
  20. P

    sumifs help needed

    Atatced is a sample of what am tryin to calculate on my summary tab
  21. P

    sumifs help needed

    Does anyone know a fomula I can use to populate sheet4? I ae thousands of lins of data in the other sheet and would like to summarize whats been cleared on a weekly basis at a certain point/between this certain points in in time when the checks clear. Summary( Sheet 4) Payments NA EMEA...
Back
Top