• 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

    Formula required on which week value surpass the requirement.

    Thank you, @p45cal. I find it difficult to understand this formula. Can you help with non-dynamic array formula? Thanks.
  2. P

    Formula required on which week value surpass the requirement.

    Hi @p45cal I sincerely appreciate your time. This formula is not working when I try to apply it to my original sheet. I've got to comprehend the Lambda formula. In order for me to use this formula in my original reference workbook, could you kindly explain how it functions at least how to use...
  3. P

    Formula required on which week value surpass the requirement.

    Hello, I need assistance with a formula to determine which week values exceed the requirement. I have attached an excel file for reference; formula help is required for column Y, highlighted in orange. pls help.
  4. P

    Combine multiple sheet skipping Errors.

    @vletm "Recovered_Sheet1" is the sheet name of the attached excel file. Thanks for giving your time.
  5. P

    Combine multiple sheet skipping Errors.

    The file received from the colleague is a customer to which I can't demand a report in the desired format, he collects this data from his internal application and shares it with us to resolve the issues which are in the attached reports. I am trying to merge all the numerous files into a master...
  6. P

    Combine multiple sheet skipping Errors.

    Thanks, @vletm for your response. Sample files are attached in my first post, I receive it from the mail in a zip file from another colleague which he fetches from our org internal tools and he saves it in excel format.
  7. P

    Combine multiple sheet skipping Errors.

    I have multiple excel files whenever I open it gives the error "The file format and extension of "file name" don't match." The file comes from an automated tool. And when I try to combine all excel files through power query it again gives the error "External table is not in the expected...
  8. P

    Test result based on the criteria.

    Still, the result is not coming based on the set criteria. I have highlighted the incorrect result in Red color for your reference. Thanks for giving valuable time. You can also use my earlier details sheet for reference which is a somewhat actual file I'm working on.
  9. P

    Test result based on the criteria.

    It seems the given reference file is not enough to understand the requirement. Attaching an updated file for reference.
  10. P

    Test result based on the criteria.

    Thanks for putting effort, But It appears the formula is not working as required. When I changed the DC value of cell D6 to -47 (-48 to -60), It still shows the result pass instead of fail. I also changed the C6 cell input DC to AC (200-260) and kept the value -47, it still shows the result pass...
  11. P

    Test result based on the criteria.

    Greetings, I require a formula to help to get the result based on the criteria. Criteria are mentioned in the range column of B4:F4, based on the requirements, the result of the Pass/Fail of the test is required in column "G". I am doing this task by checking the value manually. I am looking...
  12. P

    Break column data into multiple rows if contains specific text.

    Thanks your very much @p45cal . These steps are very helpful for me. I have to just change column range in power query for Replaced Values and Merged Columns for my other sheets which has data in more than 55-120 columns. That's it. Exit and load and refresh the sheet. Voila results are done.
  13. P

    Break column data into multiple rows if contains specific text.

    @p45cal The result is perfect. Could you please guide me how did you do it in Power Query step by step. I'm new with Power Query. The many files are in .CSV format. Thanks.
  14. P

    TextJoin distinct values

    Hi @jonastiger Please check attached.
  15. P

    Break column data into multiple rows if contains specific text.

    @eibi Thank for your response. The formula did work for me. Yes, is It also making system little slow and the minor issue of repeat text which you have highlighted in red text. Actually, I have 15 files like the sample sheet. I add all the sheets one below the main file. The result goes over...
  16. P

    Break column data into multiple rows if contains specific text.

    Hi, Attaching excel file for reference. I facing problem to transform data in desired format. I want to break column data into rows data from wherever certain text "sh firmware card" exist. Column-A data will remain same for rows data. I have mapped a sample result in sheet1 of the attached...
  17. P

    Auto data fill based on previous cell value reference.

    Thanks @bosco_yip this is very much helpful.
  18. P

    Auto data fill based on previous cell value reference.

    Hello Friends, Seems I could not explain the problem properly due to that I have not received any help as of now. I am trying to explain in simple manner in this attached file. Hope to get some response. If any cell having the matching result only the next cell should also have the same...
  19. P

    Auto data fill based on previous cell value reference.

    Yes @pecoflyer Today I have posted the requirement on other portals to get resolution. I haven't received any update from anywhere as on now. Thanks.
  20. P

    Auto data fill based on previous cell value reference.

    Dear @bosco_yip could you please help for this solution. I'm still looking someone to respond. Thanks in advance.
  21. P

    Auto data fill based on previous cell value reference.

    Please check attached sheet is having two tables. First is the value I am getting with my own formula reference second table shows expected result. I am looking for a formula reference. If below entry shows in any cell then only the next cell should have the same data. 260SCX2 130SCX10 112SNX10...
  22. P

    Sum value between two dates with certain criteria.

    Hi @pecoflyer , Can you please help me to understand this formula. How this working. I've tried to understand it by splitting the formula but the expected result not coming. Sorry for bothering you. Thanks in advance.
  23. P

    Sum value between two dates with certain criteria.

    Thanks @pecoflyer for quick reply.
  24. P

    Sum value between two dates with certain criteria.

    Thanks @pecoflyer for your response. I just copied and pasted in column "G2" but that is giving error result. Can you check what i missed.
  25. P

    Sum value between two dates with certain criteria.

    I could able to create the formula. But the formula is little large to understand for some. Can you help with some short formula for required result.
Back
Top