Recent content by cyrilz

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

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

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.

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.

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

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

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

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

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

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

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

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

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

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

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