Search results

Thanks Sam for the Code its working ..... :)

Raj

Hi Nayayan, Good day! Sorry bro I dint catch to update the Const clngSplitCol As Long = 3 Code is working absolutely fine. Thanks for helping me and understand the same. Hi Marc, Thanks you now code is deriving the result. Thanks a lot :) Once again thanks all Ninjas for helping on...

hi Sirjb7, Thanks for the excellent formula. since the data range and number of columns in Sample file 1.xlsx are more hence macro would help me Sir. Hi Marc L, I tried to run the above code for Sample file 1.xlsx, but found an error. The code provided by Sam is working for small range...

Raj

Hi Sam, Thanks for your support. When I try to implement the above code for large set of data the value split is not happening. I updated the range in the code but the field values in column are not being split in the out put worksheet. Regards, Raj

Dear Team, In the sample file under data sheet I have four columns. From Column "field" I am looking for a cell value to be splited in for the number of times # is present and the data need to added in the new row. In the output sheet the sample is created manually. Kidnly help on this...

Tahnk you Luke this helped me lot. Thank you, Shan

Hi Luke, Thanks for your response. I am still facing the #### errors if update the formula to =(B1-A1)+B1-A1. Regards, Shan

Hi Abhijeet, Thanks for your response, I am looking for all the ranges like 10-15 Min, 15-20 MIN, 20-25 Min, 25-30 Min, 30-40 Min. Using nested if the formula should result the respective range. The above formula work only for "<10 Mins". Regards, Shan

Dear Friend, I have 23:50:00 (11:50 PM) in A1 and 00:05:00 (12:05 AM) in B1. I Subtracts B1-A1 I am getting an error. Kindly help me to solve this problem. Regards, Shan

hi Ravi Ihave uploded the sample file for your reference.

Dear Team, I have time value in cell L2 in HH:MM formate. I am looking for If my call value is <=0:10 I need to display "< 10 min" M2 column, if value is between >0:10 and <0:15 M2 shoud diplay as "10-15 min" and value is between >0:15and <0:20 M2 shoud diplay as "15-20 min" Similary i am...

Dear Ninjas, Please help how to get the error status as "Pass" or "fail" under Column E of the attached file. The conditions are, &#62; If same application # (Application 46) have two error like "Address" and "Agent Id" Errors in column D then my column E should show the result as "Fail"...

hi SirB7, You are right I had some to be corrected.... its working. Thank you.

hi SirB7, Thanks for your responce... but =COUNTIF(A2:G2,"VL")+COUNTIF(A2:G2,"PL")+COUNTIF(A2:G2,"SL") is resulting as one instead of 3, where its VL PL and SL are aprearing in the range.

Hi Dear Team, I have the below data and need to count based on the condition. 1-Jun 2-Jun 3-Jun 4-Jun 5-Jun 6-Jun 7-Jun VL B B PL SL I need to the formula which counts only for VL,PL and SL and ignore B and blanks. Thanks for your support.

Thank you Hui

Dear Friends, From the attached file 1&#62; I am not getting the accurate result for the SUM of Column value BL+BQ= in Column BR 2&#62; AND SUM of Columns BM+BN+BS+BT = in Colulmn BW (If any cell value is NA it should ignore and sum the other values) Attachment Link...

Hello Sir, I have a file which has a drop down list. Every time I try copying the data from it I am getting the image as a paste result. Can you help me to copy the specific hilighted country from the " Deal Country" field. I have attached the sample file for your reference. Thank you...

Hi Sir, I got solution for this situation =((B1-C1)/B1*100)*30/100 Thank you again for your support :)

In addition to my previous problem, the person having less defects should have more score, also considering the # of volumes.

Thank you Hui, How about in case of one more parameter to consider like Defects, again score is 30 to be distributed among all the 5 people. Person Volume Defect Score A 150 1 ? B 75 0 ? C 125 2 ? D 200 5 ? E 100...

Hi Sir, I have the 5 people working on set of volumes.I Have the score of 30 which is standard. This need to be distributed among the people worked on the volumes. I need to get what is the score of Person A out of 30 and similarly for all the people. Can you please help me with the formula to...

hi NARAYANK991, I am really sorry I am still beginer in using CF, but what I thought was every time I pull the report and run macro would easly hilight the set details with message alert. 1. The number of rows in your list --&#62; above 1500 2. The number of sets --&#62; 3 set SET A, SET B...