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

    Remove "-" from a excel file

    Hi Team, I am getting an attached file from our system, and it contains "-" for some empty cells. I want to remove those or replace them with "0" but this should not affect to the negative figures. It would be great if you could give me a VBA code to do this. Thank you, Lasantha.
  2. L

    by Date Individual Production Summary

    Hi @Shawnhet , Thank you very much for this. -Lasantha.
  3. L

    by Date Individual Production Summary

    Hi @Shawnhet , Sorry for the delaying response to this. This is great , thank you very much for you time.:) Completion volume on the 1st table, shows total for the entire month. Could you please edit it , as display for the selected date. Ex: when we select 7/15/2022, from the dropdown, I can...
  4. L

    by Date Individual Production Summary

    Hi @Shawnhet , Thank you very much for you time. This is great. :awesome: Could you please help me to fill 1st table with selected date only. (From date List) If you could arrange something for it, that would be a great help for me. Thanks again for your time. Lasantha.
  5. L

    by Date Individual Production Summary

    Hi, Could you please help me.
  6. L

    by Date Individual Production Summary

    Dear Team, Kindly look into the attached template. It contains daily allocation and completed volume by date and employee. Could you please help me to get a summary by individual and by date individual completed volume to the summary sheet. Thank you very much for your time (Excel 2016)...
  7. L

    VBA Code to Run a Macro until press the "F9"

    Dear Team, Could you please give me a VBA code run a specific Macro until we press the "F9" button. Macro should repeat until we press the "F9" button. Thank you for your time. Lasantha.
  8. L

    Formula to get Lowest performing Students

    Dear GraH - Guido, I am using Excel 2013. I don't have that function. Could you please give me a different formula. Thank you.
  9. L

    Formula to get Lowest performing Students

    Dear Team, Kindly review the attached template. Data sheet contains students yearly performance. Could you please give me a formula to get only Lowest performing students to Summery sheet. Thanks for your time. Lasantha.
  10. L

    Attendance Data

    thank you.
  11. L

    Attendance Data

    Hi, I am checking whether it is possible to get who exit early. Thank you very much , you helped me to resolve one part.
  12. L

    Attendance Data

    Dear Team, Kindly look into the attached template. Is it possible to identify those who exit early by the Shift. (Shift start and end time has given). Thank you. Lasantha.
  13. L

    Late Entries

    Great, Thank you very much, Is it possible to identify those who exit early by end time. Kindly see the attached file. Lasantha.
  14. L

    Late Entries

    Dear All, We have 3 different shift as per below. I need a formula to identify late arrival entries. Could you please help me to create a formula. Start Time End Time Day 8:40:00 AM 5:30:00 PM Night 7:10:00 PM 4:00:00 AM Straddle 3:00:00 PM 12:00:00 AM Name Shift IN Time Late...
  15. L

    Productivity dashboard.

    Dear All, Kindly look into the attached template, Data sheet contains employee productivity number by system of each date, We select date drop down , enter productivity numbers, vlookup total to summary sheet ,clean data and insert next day numbers. We are planning to automate this. It would...
  16. L

    Change the format of Numbers

    thank you
  17. L

    Change the format of Numbers

    Dear All, Kindly look into the below numbers. I just want to show negative numbers as positive and positive numbers as negative. Could you please help me to create a formula. Thank you for you time. Carrier Payment $ (240.01) $ (49.27)...
  18. L

    Vlookup help

    thank you.
  19. L

    Vlookup help

    hi, thanks for reply. this is perfectly working when one claims has comment "AAA", but there can be more "AAA" with other claims IDs as well. kindly look into the attached template. Could you please give me another formula. thanks for your time.
  20. L

    Vlookup help

    I just want to search claims which has comment "AAA" only.
  21. L

    Vlookup help

    thanks for your reply, but this doesn't work for me. Kindly check the attachment for example.
  22. L

    Vlookup help

    Dear All, Kindly look into the attached template. Is it possible to lookup only claims which comment equal to "AAA" to B column. thank you.
Back
Top