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.

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.

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

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

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 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 All, I was using the below code to remove duplicate rows. In the current scenario I have couple of cells which are merged in Column A. If I run the macro I am losing the non duplicate values. Kindly help me to revisit this code so that my Column A merged cells remain same and one of...

Hi All, From the attached file I am trying to find the total count of present in Cell D3 based on the date available in D2 comparing the Date range from E6 to EI6. I need only the present count alone for the respective date in D2. I tried to use the below formula but it couldn't work...

Hi All, From the attached workbook I am looking fr the hourly production done my employees/ respective Team. I have raw data for employee name and job End time in column B and C. currently I am getting the production result in column J and K based on the End Time alone. I am trying to link...

Hello, From the attached file I capture transaction start & end time and Break start & end time. I am looking for below conditions while capturing the time stamp 1>Without starting a job its end time should not be captured. Similarly without ending the current job the next job should not...

Dear All, In "summary" sheet of the attached template I have consolidated the availability of TL in Column E from "TL Details" sheet info using IF statement. Here anyways I am getting the expected result by putting lengthy If statements. Is there a way that we can simplify function here? May...

Dear All, I am trying to consolidate worksheets "Forms Analysis,G_drive,Scroll_Word,Scroll_PDF and System Issue" into "Summary" worksheet in the attached file. But the challenge is I need to get few common cell details from Home sheet like "Employee Name, ID, TL, and area belong to (Column D3...

Hello Sir, I am working on time study template. In the attached file I have 2 command buttons "Start and End" to capture current "Date and Time" and calculate the TAT. I have added command buttons for each row and macro is assigned to each button. With this method macro code is too long if I...

Dear Ninjas, All these days I used to update the checkpoints using drop down. I need your support for building my checklist using macro. In the file uploaded, > For every "cased ID "check points should be followed. check points can be "Applicable checks" or "Not Applicable" as in row 6...

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

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

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

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