• 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 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 &...
  2. 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.
  3. 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
  4. 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...
  5. 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...
  6. 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...
  7. S

    5 years sale comparision

    Sir can you please help to compare 5 years sale with previous years and floor wise Regards, Srinivas
  8. 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
  9. S

    duplicate printing

    sir, can i stop duplicate printing of worksheet i.e i want only one copy i f anyone want to take duplicate printing it should ask password thankyou sriniva
  10. S

    formula to sum and product

    dear sir, I need a formula which im trying but unable to get i have date c and e cells i want a formula like this c3-e3 c4-sum(e4:e3) c5-sum(e5:e3) c6-sum(e6:e3) if i just copy or drag to below cells i need this formula but whats happening if i drag or paste its coming like this c3-e3...
  11. S

    Stock Scanning

    sir Im working for a store, while stock taking we scan all the barcodes but some times we type barcode manually which is like this Example A CELLA CELLB (QTY) 0009pa004735201 0009PA004735201 0009pa004735201 0009pa004735204 Example B CELL A...
Back
Top