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...
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.
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...
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.
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...
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.
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...
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...
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.
@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.
@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...
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...
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...
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...
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.