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

    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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. jb

    testing cells with text in array formula

    I have an excel sheet test_blank which contains list from b5 to b15 with empty cells in between. These empty cells have "" values. I have an array formula in c5 to c15 which is written to generate a list without blank cells. Means c5 has value aa, c6 has bb, c7 must have cc, c8 must have dd and...
  12. jb

    combine two tables in single column without blank cells

    I have two sample tables table-1 and table-2 on sheet1 (sample file attached). Table-1 a4 to c6 and table2 a10 to c12. I want to combine two tables in single column and blank cells are to be removed in output. I have 4 solutions for creating seperate list for table-1 and table-2. 3 solutions...
  13. jb

    Finding missing and extra values from table

    there are 2 sheets in my excel file - data and report. Data sheet contains 2 tables - work alloted (k2:s8) and work done (a2:i8). Both tables has same format. Work alloted table contains worker id, worker initial and 7 slots. Each row mentions id, short name of worker and different tasks...
  14. jb

    vba for conditional formatting

    I have written following VBA code to repaint borders for my table. I have also added small testing code to apply conditional formatting on cell B11 and B12 based on value of B84. If value of B84=1 then I want to fill yellow color in B11 and B12. But it is not working. Private Sub...
  15. jb

    Conditional formatting using vba coding

    Hi Helpers, I have prepared my college timetable in excel and I have attached sample sheet here. My file contains 2 sheets - timetable and formula. I am pasting daily timetable in "timetable" sheet. There are 14 classes. 2 classes are hidden as no students are there. Now, I applied 3...
  16. jb

    How to deal with message "Do you want to replace the contents of the destination cells?

    I have an excel file with data in a table. There are some cells with value and some cells are empty. Whenever I am trying to drag the data one cell to another, it shows me a dialog box "Do you want to replace the contents of the destination cells?" Well, I want to deal with this issue. When the...
  17. jb

    Fill data in table from different worksheets based on cell value

    Hi Helpers, I have a excel file table testing with 3 worksheets - tt, mon and tue All worksheet has same table format. Now tt sheet's table is empty. I have created mon and tue sheets with data in table. As it is a sample, I have two sheets otherwise there will be 6 sheets for 6 days. I want...
  18. jb

    Search value from table based on cell value

    I have an excel file with 2 sheets - s1 and s2. In s1 shhet I am entering a value in a1 cell for e.g. HM I have a table on s1 sheet from a3 to i6. a3 contains value 1 i.e. slot no. 1 and a5 contains value 2 means slot no. 2. I want values FA and 12 in cells B3 and B4 respectively. I want...
  19. jb

    Conditional formatting

    Hi Helpers, I have an excel sheet with around 50 rows containing my students data like roll number, name and other information. Now column C, F, I and L contains task number assigned to the students. Number of tasks per day will be equal to number of students. Requirement is no task must be...
  20. jb

    find time difference in no. of hours and minutes

    How to find time difference in no. of hours and minutes by subtracting two cells containing two time values? For e.g. 11.30 and 12.00 answer is : 0 and 30 (0 hour and 30 min) 10.15 and 11.30 answer is: 1 and 15 (1 hour and 15 min) 1.50 and 2.05 answer is: 0...
  21. jb

    Thread to be closed [Closed]

    How can I close the thread to indicate other users that I got the correct solution for my thread.
  22. jb

    countif changes the range

    Hi experts, I have attached an excel sheet "testing.xls" . I have data in a table from a2 to g7. Some codes are written in c2 to g7. I have written all possible codes from i2 to i6. I have written countif formula in j2 to j6. Now if I drag the data a2:g2 to say for example a9:g9, then it changes...
  23. jb

    Need a macro to draw border

    Hi Helpers, I have a table with some data. File "format preserve.xls" is uploaded with thread. In my sheet, boxes have been created of two cells each with border only around group of two cells. I need to drag and drop a box from one location to another location within table. Now when I drag...
  24. jb

    Increasing values of some cells to balance values

    Hello Helpers, I have an excel sheet jb rank testing.xlsx. This excel sheet is a solution given by one member in this forum long back. I have any 6 values entered in cells b2 to g2. I want to add a value say 16 (cell h1) to values b2 to g2. Sum of vales added to b2 to g2 should be exactly...
  25. jb

    Balanced adjustment of cell values

    Hello Helpers, I have an excel sheet jb rank.xlsx. This excel sheet is a solution given by one member in this forum long back. My problem was to add a value say 16 to range of cells in such a way that new value of cell after adding portion of value 16 to that cell should not exceed to any cell...
Top