Search results

Hi , If we go by the data that is available in the file named Original.xlsx , how will we output one result as Actionable to STC and another as Actionable to Vendor ? Narayan

Hi , I can make out that GR number is in column E. I have no idea about any of the others that you mention. Unless you clearly specify worksheet cells and ranges , I am afraid I cannot help. Sorry. Narayan

Hi , You say this : Why do you have this special requirement ? Narayan

Hi , Please indicate which cells in which worksheet need to be filled up , and the logic that will be used to fill them up. Please explain with reference to the workbook you have uploaded. Narayan

Hi , I am not able to understand what and where things don't work. Can you be specific and explain which are the cells where your existing CF rules do not work ? Narayan

Hi , It would help if you can upload your workbook with data in it. Narayan

Hi , See the attached file. Narayan

Hi , I have no idea. Hopefully someone else may respond. @Chihiro , any idea how to implement this solely using the pivot table itself ? Narayan

Hi , See the attached file. There may be a simpler way to do this , but I am not familiar with pivot tables. Narayan

Hi , There is nothing in Excel which can help in finding nearest matches for text data ; Excel will either find exact matches or it cannot find a match. Microsoft has released a fuzzy logic add-in for Excel , but you will have to download and install it before you can use it. 1...

Hi , For any new requirement , show in the uploaded worksheet , what the end results you want are. Otherwise , I am not able to understand your explanation. Narayan

Hi , How do we distinguish between Actionable to STC and Actionable to Vendor ? Narayan

Hi , What you want done is not so easy because the text itself does not follow the rules strictly. The first , middle and last names , as well as the numeric portions such as street number and zip code can be extracted without much difficulty , but the street name and the city are problematic...

Hi , No , I did not come up with this. It came from here : https://www.mrexcel.com/board/threads/text-to-columns-via-formula.587534/ Narayan

Hi , See the attached file. Run the macro named Sheet2.AssignNames. Narayan

Hi , I am not clear on why you would need a macro for this. Can you add any more detail on what would be done after these three cells are selected ? Also please indicate whether the cells are in column B or column C ? Narayan

Hi , See the attached file. 1. A named range Tolerance has been defined and given a value of 1. You can reduce this to 0.5 or any other value. This has been used to colour cells yellow. 2. The named range Pressure has been extended till row 99. You can add more machine rows now.

Hi, See the attached file. Narayan

Hi , See if this is OK. Narayan

Hi , I am sorry if I have not been able to understand. I have manually entered the assignments in the Data tab ; can you go through the assignments and either confirm or correct where ever necessary ? Narayan

Hi , Sorry , but the answers or the explanation provided does not say anything about the questions I asked. 1. What should the macro do ? A clear and comprehensive explanation of this requirement is still not available. Should the macro fill the matrix with Ys and Ns ? YES / NO Should the...

Hi , If you know that there are 5 strings in the cell's text , the following formula can be used to return any particular string from all of the text which has been entered in cell A1. =INDEX(TRIM(MID(SUBSTITUTE(A1,CHAR(10), REPT(" ", 100)),{1,101,201,301,401},100)),1) returns the first...

Hi , Can you explain a little more ? And give more rows of data , and give the desired output in a few cases ? Narayan

Hi , I am not clear on what the macro should do. Do you want the range C8:J11 to be filled with Ys and Ns ? If so , should it be randomly assigned ? What is the meaning of random in this case ? The assignment which has been made in the uploaded workbook has 20 Ys and 8 Ns ; is this random ...

Hi , Try this in O2 and copy down. =IF(G2 = "", "", INDEX('Netfor Tracking'!$I$2:$I$3,MATCH("*" & 'M12 Pend-Closed Late'!G2 & "*",'Netfor Tracking'!$E$2:$E$3,0))) Narayan