Recent content by shantraj.antin@gmail.com

Hi Team, From the attached file I need to allocate the task managers randomly. For Example John is a task manager he should get 13 allocations equally from all the 4 locations and divided among all the employees. Similarly all the 4 task managers get random allocation for all the 4 locations...

Hi Guys, I need to sum the data form all the 4 tables into 1 table with reference to Name. Attached is the sample file.

Thank you Very much Bosco and John. Its working.

Thanks for your response Villalobos. But I just need those job names which has no error in all sub job pertaining to it.

Hi Team, From the attached file I have 3 coulmns Job, Sub job and Error in sub job. I need to find those jobs which are having all zero errors in all sub jobs. I have attached the sample file for your reference. Since I have more than 20,000 line items Jobs are merged I am not able to get it...

Hi All, I have set of data in a Column. I Am looking for a formula to identify the count of Unique values from that column. Attached is the Sample file for your reference.

Thanks All. Its working

VBA would be great Ratan.

Hi All, I have 4 tasks A,B,C,D and its serial number in column A. Based on the "Yes or No" values of each task I am looking for its serial numbers in summary table. Example: If A task value is “No” @ serial number 4,8 and 499, I need to extract it in summary table under task A. I have...

Hi Nebu, Thanks for your response. There is a problem, in my office laptop i cannot install the add in. can you please help me excel formula or macro Thank you

Hi Team, I have a set of Description in range B2 to B55 and every time I copy paste few statements in F and try to highlight even if one word is matching with the rage items B2 to B55. For example : in B4 description is "CANCELLATION AND NONRENEWAL ENDORSEMENT " and word Cancellation matches...

Hi Vletm, Thank you so much. This latest version is more robust. I tested the file it working fine. Thank you very much

Thank you Vletm. I found couple of observations 1> When I switch to other excel workbook macro is ending the code 2> When my start time is 1:30 mins file is not responding I mean cursor doesn't allow any action 3> when i click on "stop for multiple time and then click on start again file is...

Hi Vletm, Thanks for updated version. There seems to be a problem, When I click on start I am getting a compile error. Kindly help me on this error.

Wow its Amazing Vletm. I tested the file. Its working well. Thank you.