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

  1. jb

    Search for partial string using vba

    Hello helpers, I have following code to concatenate multiple cells based on condition. I have range of cells from b17 to p17 having some text. I have a word in A26. I am searching A26 in b17 to p17 and if match is found then corresponding cells from b16 to p16 will be concatenated with : as...
  2. jb

    Merge cells from multiple sheets

    Hello helpers, I have attached sample workbook here. I have multiple classes in my school and my sample workbook contains timetable of 2 grades - grade_8A and grade_8B. There can be multiple grades. There are many teachers who takes combined sessions in more than one grades. There can be more...
  3. jb

    Calculation of marks using single formula

    Dear Helpers, I have an excel sheet with students data like roll number, name and the answers they have given in quiz. Sample file: A2 to E5. c2, d2 and e2 are correct answers of Q1, 2 and 3. I want to calculate total marks obtained by each student. For that i have created table in H3 to J5...
  4. jb

    sumproduct with dynamic cell range

    Thank you bosco_yip for quick help. both formula worked Just want to know for knowledge: In my solution, why it was giving error when I tried to replace E10 and F10 in formula of b10 ?
  5. jb

    sumproduct with dynamic cell range

    Hello Helpers, I have an excel file with 2 sheets. supervision_chart and individual supervision. supervision_chart has date wise list of supervisors. I need to generate supervision chart for each supervisor in individual_supervision sheet. When I type supervisor code in B5 cell of...
  6. jb

    Copy data from sheets of different workbook in sheets of one workbook

    Dear Helper, In my school, every teacher is maintaining own workbook where he/she maintain attendance of all the classes in which he / she is teaching. For example teacher A teaches 6 different subject then he will maintain 6 worksheets in his workbook. Now every grade has one class teacher who...
  7. jb

    Copy data from multiple workbook to one workbook without opening multiple workbook

    Dear Helpers, My school has 10 grades from 1 to 10. Each class has number of subjects and each subject is taught by one or more teachers. Now, each teacher is teaching in different grades. And he / she is maintaining attendance sheet of each class in one workbook. Say teacher A is teaching in...
  8. jb

    Copy data from sheets of different workbook in sheets of one workbook

    I am trying again to explain my problem. My school has 10 grades from 1 to 10. Each class has number of subjects and each subject is taught by one or more teachers. Now, each teacher is teaching in different grades. And he / she is maintaining attendance sheet of each class in one workbook...
  9. jb

    Copy data from sheets of different workbook in sheets of one workbook

    Sorry Helper. By mistake I gave name MATHS_6_AB. It is MATHS_7_AB.
  10. jb

    Copy data from sheets of different workbook in sheets of one workbook

    Dear Helpers, I want to automatically fetch the data from multiple workbooks into one workbook. Let me explain the scenario. There are total 10 classes (subject to increase) of different grades in my school. Each class has to study different subjects and each subject may be taught by more than...
  11. jb

    Generate dynamic list

    Hello Helpers, I have an excel sheet "list" in which there is list of participants of different games is placed. This list can be updated and new participants can be entered. Now there are 3 games so there are 3 sheets with name "game-1","game-2" and "game-3" I have shown sample output required...
  12. jb

    EXCEL file is very slow

    Hi Helpers, I have one excel file which is created to manage timetable of one educational institute. It contains many excel sheets. Main worksheet is timetable. It contains many slots. Each slot has two lines - upper line is for subject and below line is for faculty name. Master timetable is...
  13. jb

    login problem in chandoo.org

    Sir, I am facing many problems in login with your website. Your website keeeps on asking login name and password again and again. When i am trying to download answer excel file of my question, it is Not allowing me to download answer file. It immedietly ask for login name and password. I enter...
  14. jb

    Find all row numbers from a table matching a value

    Hello helpers, I have a worksheet with a table from B1:F42. This table is actually receiving values dynamically in original sheet. So the names in given table keeps on changing everyday. Column A indicates numbers 1 to 7. This numbers are work slot numbers. They are fixed. Table B45:E52 is...
  15. jb

    testing cells with text in array formula

    Sir it is not working. I have used following array formula. It works perfectly if the cell does not contain anything. =IFERROR(INDEX($B$5:$B$15,SMALL(IF(ISTEXT($B$5:$B$15),ROW($B$1:$B$11),""),ROW(B1))),"") I also know the problem. ISTEXT($B$5:$B$15) is not returning false for the cells having...
Top