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

Recent content by srirajsa

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