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

    Finding time availability slot

    Please find the attachment
  2. S

    Finding empty cells and by criteria and update

    Dear all, I need to create time table by checking which professor is free at particular slot and if is he/she is free I need to allocate subject to them. attached is the file for your reference please help. I need to find the time and need to update subject that particular time thanks &...
  3. S

    Finding time availability slot

    Dear all, I need to create time table by checking which professor is free at particular slot and if is he/she is free I need to allocate subject to them. attached is the file for your reference please help.
  4. S

    Match function

    Ok sir i got the formula =IF(A6=A5,"",INDEX(walkin,MATCH(A6,date,0))) thank you
  5. S

    Match function

    sir, I need formula to extract walks in of as per the criteria in the attached file, please help Thanks & regards Srinivas
  6. S

    countifs

    Sir I want to match three three criteria and get count for example Location Designation October November Decmber XYZ SM 4500 XYZ SM 2500 XYZ SM XYZ ASM 1500 XYZ ASM XYZ...
  7. S

    Copy row data to multiple sheets in another work book

    Thank you once again sir
  8. S

    Copy row data to multiple sheets in another work book

    Sir Thanks sir its working what if we want to copy only to one column B4 in each sheet Regards Srinivas
  9. S

    Copy row data to multiple sheets in another work book

    Thank you sir its working Regards Srinivas
  10. S

    Copy row data to multiple sheets in another work book

    Sir Can any one help me with any macro to copy emp nos from emp nos Range F2 to F520 to all the sheets B4 and B24 as per below example For example Emp nos File 1 A 9325 9349 9328 9349 We need to copy to file ROughlayout Sheet 1 in B4 9325 and B24 9349 and in Sheet 2 in B4 9328 and...
  11. S

    Match Function

    Thank you sir Regards Srinivas
  12. S

    Match Function

    Thanks a ton sir its working can you tell me this part "")),"") and if I want to get data from 6 files means how to end the formula "")),"") Regards srinivas
  13. S

    Match Function

    Sir Im sending here sample file of my working SalMain is the main file I want to get data from Sal JG and SalVs Thank you Srinivas
  14. S

    Match Function

    Sir Can I find a Match (by Unique ID) and get data from different excel files For ex: File 1 e:\Vsemp File 2 e:\Jgemp Main Data File Emp No Emp Name 9325 9326 I want to check the Emp No from all the files and IF he is not present in file 1 then go to file 2 and get data Iam...
  15. S

    5 years sale comparision

    Thank you sir I will try
  16. S

    5 years sale comparision

    Sir, nothing problem any better presentation like dash board Regards, srinivas
  17. S

    5 years sale comparision

    Sir can you please help to compare 5 years sale with previous years and floor wise Regards, Srinivas
  18. S

    showing value error in subtraction

    thanks for the detail sir
  19. S

    showing value error in subtraction

    thank you narayan sir if you have time can you explain how it calculates regards, srinivas
  20. S

    showing value error in subtraction

    sir this is the FILE
  21. S

    showing value error in subtraction

    Sir, I have some cells to substract which also include blank cells so the error is showing as #value so please help me thanks srinivas
  22. S

    duplicate printing

    thank you sir, its working sir we do have an software called Oriel Retail Software, I have taken data from that and keeping as recent time s we are regularly having problem with our server. This excel sheet may helpful instead of writing manual bills. Once again thanks so much regards...
  23. S

    duplicate printing

    Sir, this is the file i want to print each sheet only one time if any duplicate print it should ask password, once password entered it should allow duplicate printing https://onedrive.live.com/redir?resid=7CD92E34822F550B%21135
  24. S

    duplicate printing

    Sir
Back
Top