Search results for query: *

Hi everyone, do you have a hint for me, whether there is a non-macro solution to sum up the values of a column - but only those cells that contain a hardcoded value. Cells that contain a formula should not be summed up. e.g. a1: =4+2 a2: 2 a3: 3 a4: function(a1:a3) --> result = 5 Thanks...

Hi Guys, I have a table containing 9 columns. Each column in every row can, but does not have to, contain a value. There is a maximum of 4 cells per row containing values. What I would like to have is a formula that helps me to identify in which column per row I have my values as shown below...

Hi, I am trying to make a container MovieClip in which I would like to load another Movie. The loaded Movie would have to know, what size the container would have in order to set the position of some images dynamically. Is there a way to get the ClipHolder's width and height? I tried to use...

Hi Folks I have a question on referencing objects: In AS1 + AS2 when I used "this" within a function I was able to control the object calling the function. Now in AS3 it seems as if this would always target the timeline on which the function is defined. How can I make sure to reference the...

Hi guys, I wonder if you could please help me with this problem. I have an excel file with about 800 lines in a column that have a hirarchy shown as indent of the content of a cell. like item 1 item 2 item 3 item 4 item 5 item 6 item 7 item 8 item 9 The problem I have is...

Hi folks, could you please help me on the following: I need to find the position of a value in an unsorted column. Example given: index position of next higher or same value _____________________ 1 10 2 3 5 4 5 3 9 4 9 5 9 5 9 3...

Hi Folks, I'd be very grateful if you could help me on the following: I have a MS Word document that is connected to a Server via form fields. Depending on a boolean value of a form field a graphic should be displayed (or not). For a reason that does not need to be explained here it is very...

Hi, my challenge looks like this: I have several values in a column like: **Manufacturing **Warehousing ***VARIABLE COSTS ****OPERATING PROFIT I am longing to eliminate the asterisks. So I would like to search the cells from the right for the first asterisk to appear so that I could do...

hi folks, would be great if you could help me out with this: i have a column containing values like say: *Total Gross Sales *Allowances & Discounts **Net Sales ***VARIABLE COSTS ****PROFIT CONTRIBUTION ****Organisation Expenses ****Other Income ****Other Expenses ****OPERATING PROFIT what i...

Hi Folks, Would be great if somebody could give me a hint on this. I have a table that roughly looks like this: Profitcenter Sales Quantity Net Sales 100 30 465 100 10 470,12 100 12...

Hi, does anybody know by chance whether there is a shortcut in EXCEL for 'paste special - values' and 'paste special - formulas'? Many thanks in advance regards

Hi Folks, this is a tough one that makes my brain ache: I have a list of calendar weeks and I have to find a formula that tells me whether the last day of the month is in this week so that the cell displays "YES" in case the week contains the last day of the month and "NO" if it doesn't. E.g...

Hi, I have this excel file that opens a dialogue box when ever the file is opened. It says that there were automatic links to information in other files and whether I would like to update this information or not. Unfortunately I cannot find those links to the other files. I'd like to remove...

Hi folks, does anybody by chance know whether (and how) it is possible to colorize mails in the inbox according to their sender? e.g. Steven's mail would be displayed blue, Mary's mails in green... Thanks in advance! regards

Hi folks! Does anybody know how I can change the colors of the UI-component scrollbar? I mean in MX it was pretty easy using FStyleFormat but in MX2004 I have no clue! Thanks in advance! regards

Hi, could you please help me with the following issue: I don't know why, maybe I used a shortcut without knowing but since today morning, when I use Excel the use of the cursor keys does NOT change the cell but the view. I can only go to another cell usign the enter key or the mouse. My cursor...

Hi, once I heard, that version 6 of the flash player for mac had a bug so that all framerates between 19 and 30 were played at 19 fps which can be quite annoying due to choppy animations. So I decided to make all my films play at 31 fps. It is obvious that 31 fps result in bigger filesizes than...

Hi, please can you help me out with this. I made a website for a friend of mine. www.kempf.cc When you choose the html-version, you will find a pretty simple javascript-controlled menu showing and hiding depending on the mouse position. The content of the site is shown in an i-frame below the...

Hi folks, could you please spend a minute on my question? Here is my problem: A friend of mine wants to write a new mail (in OUTLOOK XP) using an address from his address book. He opens a new mail. Now one sees the address bar with the "to" button. When I click this button the address book...

Hi, Please help me with the following. I created an audio menu (which can be seen on http://www.koschitz.org/florian/fjhpneu/de at the bottom of the page). Even though the soundfiles are cut very precisely the sound doesn't loop properly. There is always a tiny delay before they start over...