• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. shantraj.antin@gmail.com

    Remove Duplicates

    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...
  2. shantraj.antin@gmail.com

    If function for dated range

    Hi Jake, Thanks and Appreciate your quick support. Your formula is working fine for me. 5.70 is expected 95% of head counts. Regards, Shan
  3. shantraj.antin@gmail.com

    If function for dated range

    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...
  4. shantraj.antin@gmail.com

    Linking multiple data Validations

    Sure and thank you Deepak
  5. shantraj.antin@gmail.com

    Linking multiple data Validations

    Hi Deepak Thank you its working for J
  6. shantraj.antin@gmail.com

    Linking multiple data Validations

    Hi Deepak, I applied the dependent drop down. But I am struck with the SUMPRODUCT function applied @ column J and K. I am looking for the result in Column J and K based on the selection made from E2 and F2. Note: IF E2= All, or IF E2= any value from drop down and F2= "All" then result should...
  7. shantraj.antin@gmail.com

    Linking multiple data Validations

    Hi Deepak, I will try to link drop drown. But I need your assistance when if comes to modifying the formula in column j and k. Thank you
  8. shantraj.antin@gmail.com

    Linking multiple data Validations

    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...
  9. shantraj.antin@gmail.com

    Help on time stamp

    Hi Deepak, thanks a lot !! Its working .
  10. shantraj.antin@gmail.com

    Help on time stamp

    Hi Deepak, I need your help again. I am sorry may be I was not clear above in explaining the condition, If break is started it should end and if break is not ended the job should not end. Here I am able to end the job without ending the break first.
  11. shantraj.antin@gmail.com

    Help on time stamp

    Thanks for your response Deepak. From your attachment all the conditions are working fine. But if job start time is captured and it should allow to end the job. but here without break start and end time the job end is not working. Hence job end should work without break time. next job may...
  12. shantraj.antin@gmail.com

    Help on time stamp

    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...
  13. shantraj.antin@gmail.com

    Simplification of IF statement

    Thanks Narayan. It works. Excellent!!
  14. shantraj.antin@gmail.com

    Simplification of IF statement

    Hi Faseeh, I added the code to vba module and tried to use the UDF in my attached file. But I am confused while selecting the input details for this UDF. If you dont mind can you please help me with one example on how to use this UDF in my attached file. Thanks in advance.
  15. shantraj.antin@gmail.com

    Simplification of IF statement

    Thanks a lot Faseeh, I will try with the above code.
  16. shantraj.antin@gmail.com

    Simplification of IF statement

    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...
  17. shantraj.antin@gmail.com

    Wroksheet consolidation

    Hi Luke, With the following code I am able to consolidate, but still I am not able to fetch the data from home sheet like "Employee Name, ID, TL, and area belong to which are in (Column D3 to D6)" to summary Sheet. Also the following code considering the home sheet while consolidating...
  18. shantraj.antin@gmail.com

    Wroksheet consolidation

    Thank you Luke.
  19. shantraj.antin@gmail.com

    Wroksheet consolidation

    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...
  20. shantraj.antin@gmail.com

    Time Study template

    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...
  21. shantraj.antin@gmail.com

    Checklist using Macro

    Thanks Luke for your support. Code is working fine. The double click option you have put is more comfortable to use. Thanks a lot :)
  22. shantraj.antin@gmail.com

    Raj

    Raj
  23. shantraj.antin@gmail.com

    Checklist using Macro

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