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

    * * * E V E R Y O N E - P L E A S E . R E A D * * *

    Hi all, This is the most serious yet unofficial blog I have ever come across. Every one try to achieve the best and they are trying to learn the best ways to work with excel. However, NO ONE IS WORKING FOR ANYBODY. We have this in our mind when we post our questions. But, we know that some...
  2. A

    TABLES AND DATA

    Hi all, I have a table with four headings and names under each heading. I want to male another table with the names in column a the b,c,d and e have the same headings. I want to put 1 in the cell under the heading if the name is mentioned in the original table, and 0 if not. How can this be done?
  3. A

    water marks

    Thanks Luke. This is what I thought at the beginning, but can't we suggest the idea of linking a background mark to a cell value to microsoft? :)
  4. A

    water marks

    Hi How can we add a waer mark in a worksheet and make this water mark change according to a cell value?
  5. A

    selecting cells

    Hi all, This is something new. We all select cell(s) in excell, and we see that when the cell is selected all is done is that the cell is double-bordered. What I need to have is when I select a cell, I want it to change color and font. How is that done. All help is highly appreciated.
  6. A

    drop downs

    Thanks all. What I mean is First I chhose the subject, then I put the marks. I save the file. After that I may choose another subject and put different marks. Now I want to recall the marks for the first subject when I choose it from the DD list.
  7. A

    drop downs

    Hi all, I have a worksheet that contains the following: Pupils names and their grades I have a drop down list with the names of the different subjects: English, science, maths, etc What i want to have is the following: When I choose a certain subject from the list, I want the grades for...
  8. A

    multiple conditions

    Thanks SirJ
  9. A

    multiple conditions

    Hi all, In A2 I have a text that I would change. In A3 I want to have a condition that does the following: If A2 = grapes then A3 shows fruit If A2 = lettuce then A3 shows vegetables If A2 = veal then A3 shows meat If A2 = anything else A3 shows poultry How can I write the formula?
  10. A

    Picture calendar

    Thanks sir.
  11. A

    Picture calendar

    Hi Chandoo, I downloaded your picture claendar and I like it very much, but I have a question: Why do the pictures appear in black and white although I insert colourful pictures? Thanks a lot.
  12. A

    protect formulae

    Hi all, What's the best way to hide and protect cells and formulae?
  13. A

    dropdown lists

    Thanks Luke M. I appreciate your reply.I'll try to upload a sample file.
  14. A

    data validation

    Thanks all
  15. A

    dropdown lists

    Hi all, This is about dropdown lists to be used in dashboards. I have three dropdown lists ( class, name, period ) class list shows ( 6, 7, 8 , 9 ) I want the names list to display the names of class 6 when I choose 6 from the class list, and so on for classes 7 , 8 and 9 so that I can...
  16. A

    if with 2 conditions

    Hi, How can we perform coditionals conditionally? ie, in A2 there is a dropdown list with 4 choices one is empty. in A3, I want to perform certain conditions one for each choice in A2. How can this be done?
  17. A

    cell reference

    Thanks Luke but I could not figure out how to do it. Could you pls write an example formula?
  18. A

    cell reference

    Can the last formula be used if I want to add a third column so that when I choose a name from column A the corresponding cells in B and C appear?
  19. A

    cell reference

    Thanks for the quick reply, Luke M. I wish we met in person, you would be a great teacher :)
  20. A

    cell reference

    Thanks everybody, The formula is very good and it works well as long as I choose names from the original list, but if I choose a name that is not in the original list, the formula comes up with an error #N/A. Can we add something to the formula to make the error blank?
  21. A

    cell reference

    Hi, In A2:A10 there are numbers from 1 to 9 In B2:B10 there are names. I want to make anothe list in B20 onward where I want to choose some of the names from B2:B10. What I need is how to show in A20 onwards the values from A2:A10 that correspond to the name I choose. Any help is highly...
  22. A

    data validation

    Why can't I make data validation (drop-down list) referring to other worksheets?
  23. A

    multiple conditionals

    Hi, condition1: If(c2="name1";d2;"") condition2: If(c3="name2";d3;"") condition2: If(c4="name3";d4;"") condition4: If(c5="name4";d5;"") A2 has a drop down list with text_1, text_2, text_3, text_4 In A3 I want to put all 4 conditions like this: If(A2="text_1";condition1;""); if A2 =...
  24. A

    conditionals

    Thanks for the reply
  25. A

    conditionals

    Hi, In A2 I have a drop down list of 4 choices. in A3 I want to put a formula that changes when the choice in A2 changes; eg in A3 if the choise is CHOICE1 then the formula is ( sum b2:b5 ), if it is CHOICE2 then the formuls is (if B6=7,C7,""), etc. so that the formula changes with the...
Back
Top