• 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

    number issue

    suppose I have a two digit number, eg 86 in A2, How can I insert a symbol between the two digits in B2 . the number will be as follows: 8/6
  2. A

    reference issue

    The message says that I need to enter a paranthesis ( or ) at the right place. I put it at the end, another message appeared saying you entered a few arguments for this function
  3. A

    reference issue

    Thaks dear, The formula shows an error at -1 which is at the end of the formula. Excel highlights it black and the formula does not work
  4. A

    reference issue

    Thank you anupagarwal06, The formula works pretty well, except for one thing: when I put the value 6/1 in A which is formatted as text, it will return to 40695 in D. I want the same 6/1 or whatever value to appear in D. I also formatted D as text
  5. A

    reference issue

    After trying the pivot table several times, I found that it is not the best solution, beacuse I want to relate cells D E and F with other sheets.
  6. A

    reference issue

    good suggestion, Fred, Thanks a lot
  7. A

    reference issue

    Ann appears twice: next to 1 and next to 5 in A John appeared three times, next to these values: 2, 3 and 9 the same for the rest, so all appearances are included in D E F
  8. A

    reference issue

    This is what the end result should be: A B C D E F 1 Ann Ann 1 5 2 John John 2 3 9 4 Sami Sami 4 7 5 Ann 7 Sami 3...
  9. A

    reference issue

    Thanks Fred, I mentioned D, E, and F because the names in B may appear more than once, so if a certain name appears in B2, B5, and B7, the values should appear next to it in D, E, and F
  10. A

    reference issue

    Hi all, I have this work sheet column A has numeric values that are fixed. column B has dropdown lists in each cell with names. I may choose whatever name in each cell in column B My problem: Column C has all the names the dropdown list displays. I want cells Column D,E,F to show the...
  11. A

    date issue

    thank you, all
  12. A

    date issue

    I have three cells A1, B1, C1, D1 In A1 I write the month in B1 I write the date of the day in C1 I write the year How can I make excel put the day's name in D1?
  13. A

    Standard deviation

    How do I calculate the Standard deviation for some records?
  14. A

    Music in excel

    Can I insert an audio file that plays once I start my Excel workbook? How?
  15. A

    hiding formulas

    Thanks a lot for your suggestions. But I have a very large workbook with more than 300 worksheets.
  16. A

    zero or no zero

    Thank you all This is really very kind of you
  17. A

    hiding formulas

    Hi Can I hide all the formulas so that nobody can see them, but they can use the worksheet. I don't want to use a password.
View older results
Back
Top