• 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. M

    IF statement

    Thank you so much so I can do this next time could you explain to me how this formula works
  2. M

    IF statement

    If the text in any of the retailers says Immediate Deletion or Mid-High Deletion the deletion column should then say yes. If all the retailer columns contain text saying either not ranged or safe then the deletion column should say no.
  3. M

    IF statement

    There are have 3 retailers the stock products I have a list if any of the items are at risk of deletion by any on the 3 retailers. In my Deletion column I want to identify if the product is safe from deletion or if it is at risk of deletion from any of the 3 retailers.
  4. M

    Pivot Table Sub Totals

    Thank you
  5. M

    Pivot Table Sub Totals

    The second lot that you have listed is what I am after. How did you do that?
  6. M

    Pivot Table Sub Totals

    Sorry reloaded the file
  7. M

    Pivot Table Sub Totals

    In my pivot table I have 8 rows I setup subtotals for all items listed in the pivot. However in the subtotal it only loads in the items description and does not load in the text from the other rows. How can I get the other text to load into the subtotal?
  8. M

    If nested equation help

    That works Thank you so much for your help
  9. M

    If nested equation help

    Thank you for that is there a way I get my answer in one column so I can have text saying what the product is?
  10. M

    Index Match Array Problems

    I am trying to match one value on a worksheet and return all products that match the value. Any item with the date MAT to 16/04/17 as well as type and return a list of items that match. When I use the formula the same item keeps appearing. The formula I am using is =INDEX(Sheet3!$B$5:$B$1206...
  11. M

    If nested equation help

    I want to identify if a product was new in 2017 or 2018 as well as if the product was existing or has been removed. To identify this I am using when the item was first sold. The equation I used was if(B5<Q4,"Exsisting"), if(B5="na",Delete),if(and(B5<=Q4, B5>=R4),"NPD 2017","",if(and(B5<=Q5...
  12. M

    Custom Format Number

    I want to change my variance I have to be rounded to nearest thousand or million and also show + or -. For example This Year Last Year Variance What I want displayed 10000 200000 10000 -10K 40000 60000 20000 +20K
  13. M

    If And Formula with Index Match not Working

    I managed to get the formula working, my excel must of had a problem. Thank you again for your help
  14. M

    If And Formula with Index Match not Working

    This formula does not work if there is not a direct match if the numbers are within the min and max range. For example: Sales: $25,600,000 Retail M2: 250 Sales Per Day: 310 Location: Major City There is not match but if I change the above details to match a stores information there is a match
  15. M

    If And Formula with Index Match not Working

    It is similar but I need to do this with different stores now and I do not no what equation I can use to replicate the last spreadsheet outcome
  16. M

    If And Formula with Index Match not Working

    I tried to apply the formula on that page to my situation but I could not get the formula to work
  17. M

    If And Formula with Index Match not Working

    Here is a spreadsheet, my formula that I am having issues with starts in column A7 as you can see all stores are loading into the table not just the stores that match my IF statement
  18. M

    If And Formula with Index Match not Working

    I am wanting to compare a new store to existing store performance. Any stores that meet the criteria such as same location, sales within 5%, GP within 10% and size within 10%. The below formula loads in all store names not just the ones that meet the criteria can someone tell me what I have...
  19. M

    Comparison Calculator Formula

    Thank you that is what I was after can you explain how you did this so I can replicate this next time I need to do this
  20. M

    Formula for Multiple Criteria Match and Return Whole Row of Data

    Hi yes they are the same thread thought re wording the problem and giving more information may help
  21. M

    Formula for Multiple Criteria Match and Return Whole Row of Data

    I want to match a store on multiple criteria which are listed below and return all stores that match the criteria. Can someone give me a formula I can use to match on these criteria and return the results I am after. Conditions 1. If size within 10% 2. Store Demographic same 3. select...
  22. M

    Comparison Calculator Formula

    Hi instead of matching on one criteria at a time I want to match on all of them at the same time
  23. M

    Comparison Calculator Formula

    Sorry the new store was not on the attachment I have updated the sheet
  24. M

    Comparison Calculator Formula

    Objective I want to create a calculator that lets me know when a new store is purchased what stores are similar. When a store matches on the below criteria I want the all the stores information in the table to appear. Criteria Store size within 10% of new store Store same demographic Store...
Back
Top