Search results

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.

Hi Team, In some of my meetings, time exceeds than the scheduled time. Hence I am looking for a meeting time tracker. I have attached the sample file for your reference. If the meeting is scheduled for 90 mins and discussion points are 6. Once I start the first discussion point it should...

Hi Team, I am looking for pop up alerts for the attached checklist. A1 to A17 I have the data. I am looking for pop up in 2 scenarios 1> When "No" is marked and no comment is updated 2> When "Yes\No\NA" nothings is marked Sample is attached for your reference.

Thanks guys for the formula. But still excel is very slow when I past special values. Its taking longer time to apply for all the 6 lakh line items.

Hi Team, In the attached sheet I used the formula IF(SUMPRODUCT(($B$2:$B2=B2)*($J$2:$J2=J2))>1,0,1) to identify single count for duplicate values. With this formula my 6 Lakh line item worksheet is very slow. Can we replace this formula to increase the efficiency. Kindly advise if we can use...

Thank you Somendra

Hi All, In the attached file, I am looking for solution to few of the excel questions. Please help me to solve these problems.

Hi Somendra, Thank you friend. Its working. :)

Hi Team, I have data of 2000 line items, For which I am looking for a audit count. In the attached file I have "Audit Job" in column "F". In column "I " I am looking for the count of jobs audited for Raj and Ram from Range A5:c12. Kindly help me to derive the formula in I5 and I6. Thank you

Hi Narayan, Thanks a lot. Its working fine. Regards, Shanthraj

Hi Narayan, Thanks for your response. Can you please help me to get the desired result to remove duplicate rows and retain single row. Regards, Shanthraj