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

    Displaying arguements in a UDF

    Hello Sachin, Starting with XL2007 you can only have the name of the function displayed. With earlier version , you would need "Microsoft HTML Help Workshop" in order to create an .CHM file (HTML pages gathered into a unique help file). Once this is done, you need to associate your UDF...
  2. C

    Change text string returned as a result of a formula to real text you can edit

    Sorry for my misunderstanding. An example file would be neat of course, and is always appreciated Regards.
  3. C

    Change text string returned as a result of a formula to real text you can edit

    Hello Claudine, Not sure why you want to convert a formula to text, but have you tried these steps ? 1/ select the cell containing the formula, 2/ Press F2 3/ At the beginning of the text before the = sign, type ' and press return... Regards.
  4. C

    help needed on formula

    Hello Guitarman, You thoughts are rights, unfortunately the syntaw is not. The correct syntax for this function is : =SUMIF(G$1:K$310, "<4") Modify for the other one. Regards.
  5. C

    Advanced Data Validation : 3 columns

    Thanks SirJB7 but I need to bypass my IT men in both case :-) Hopefully, I can create trusted folders for my own laptop. Regards.
  6. C

    Advanced Data Validation : 3 columns

    Hi SirJB7, I've seen your post which is nice as always, but as I mentioned above, I cannot use macros (users are just way too afraid of them) just because of the "alert" popup asking to activate content. They think that there is a virus or some threat so they always close the document...
  7. C

    Visual Presentation: Status, Share, Number, Timeline - all in one. NEED HELP!

    Forgot to mention I offered a scrollable time-line sample for free here : 9-excel-tips-by-readers Sample 6.
  8. C

    Visual Presentation: Status, Share, Number, Timeline - all in one. NEED HELP!

    MAybe you can refer to the following posts from Chandoo : Burndown Chart Inside it you'll find useful links to Timeline and other dashboard items Timelines But I doubt you'll cope with this in a week or two. At least a draft of it would be done. Hope this help cyril
  9. C

    Formula to extract Name that appears most frequently in a List

    Hello Victor, I cannot acces your files (blocked by proxy at work), but I assume you will need a helper column in your reference data sheet. This column will count the occurrence the pair club/player already appeared above in the list. Let me illustrated this : .| A B...
  10. C

    Advanced Data Validation : 3 columns

    Hello again, I've encountered another problem, since I wanted several sheets to have the validation lists mentionned above. Data validation lists don't accept references to other sheets. I've used Named ranges (3 of them, something bearable for my end-users, they won't even know about them...
  11. C

    Forum Avatar ????

    Thanks a lot oldchippy, I forgot about this Gravatar thing. I've changed it and it worked. Waiting for cache to be flushed. Cyril.
  12. C

    Forum Avatar ????

    Hello All, I've just changed my mail in my profile and my avatar changed to this "ugly" angry face. CAn't find any way to cahnge it back? Can anyone help me ? Cyril
  13. C

    Advanced Data Validation : 3 columns

    By the way, could be and interesting Formulas Forensic topic...
  14. C

    Advanced Data Validation : 3 columns

    >Luke M : MAny thanks for your help. Unfortunately my end-user didn't understood "Named Ranges" (too complex for him). So I changed for the following : C D E F G H ... ------------------------------------------- 1 A1 A1B1 A1B2 A1B3 1 A1B1C1...
  15. C

    Advanced Data Validation : 3 columns

    Luke, This is much more interesting for me. I like the idea of grouping horizontally the item for A and vertically the item for B. But 2 remarks : 1/ I guess B1 and B2 under A1 are useless 2/ If I have A2 and A3 to fill, I would put them on new rows. Thanks agains. cyril
  16. C

    Advanced Data Validation : 3 columns

    First of all many thanks to you all, > Narayan, Since these lists are to be used into a long list of use cases, it seems to me difficult to adapt helper columns to each row, but who knows ? The only solution I found is to add an helper refernce table containing only the first 2 columns...
  17. C

    Insert banded blank rows in a selected range(VBACode)

    Hello Vijay.vizzu, Two ways to do so : 1/ Use the Macro recorder (Menu Developer/Record Macro), once started do exactly what you described. Then press ALT+F11, search from module1 you'll see the VBA code of this macro. 2/ With the Range object, assuming you want to insert X lines below...
  18. C

    Advanced Data Validation : 3 columns

    Hello all, I've used the tip shown in a great Chandoo post here I wanted 3 columns instead of 2. I've managed to create the data validation formula for the 3rd column, but I've noticed that the 2nd one contains multiple identical lines. How can I remove all these lines from this second...
  19. C

    EXCEL 2007 - How to stop an area before the end ???

    Thanks a lot, this worked really fine
  20. C

    EXCEL 2007 - How to stop an area before the end ???

    Hello all, I want to use a mixer Bar/Area graph to show the budget/consumption progression over time. I have the following table : month Actual Cumulative Jan 2 =IF(RC[-1]=""; ""; RC[-1]+R[-1]C) ==> 2 Feb 3 =IF(RC[-1]="&#34...
  21. C

    Inserting the letter c at the end of 5 characters in a cell

    Another trick is to use 5 column, and concatening with CONCAT() all the previous columns the latest will containt "C" mhen the job is done Example : A B C D E F G Concatenation. 1 2 3 - - C =CONCAT(A2:F2) ===> give "123--C" Regards
  22. C

    Content of names changed automatically to something wrong

    Ok, I've switched back to absolutes references, and now it all OK. When I add or remove column/lines references follow. Sorry for this and thanks for your help
  23. C

    Content of names changed automatically to something wrong

    Thanks Hui, I used to do so, but the formulas didn't update when I added a column and suppressed some lines as they were supposed to do. So I switched to relatives ones, with the same result. Have you ever encountered something like this ? Here are the screenshots Before Click After...
  24. C

    Content of names changed automatically to something wrong

    Hello all, I'm a bit afraid with this one. In a shared workbook, I've defined a bunch of names, refering to columns in some sheets. When I open the file, the names refers to the values I've entered. When I click on a tab sheet, the references changes to something wrong. Let me...
  25. C

    How to count values in a column matching multiple criterias

    Which is called NB.SI.ENS in French... Thanks you so much Hui...
Top