Recent content by firegambler

Hi, thanks for your replies! I rebuilt the manual subtotals using the subtotal() formula. That way I found all the errors. cheers f.

Hi Skip, thanks for your reply. I have a document that has manually coded subtotals. I have doubts that the subtotals were calculated correctly and would like tho check the overall result. Cheers f.

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 Glenn, thanks for your post! The first part works, but only for positive values, somehow negative figures are ignored. The second part returns strange values to me like 138 for a 9 column spreadsheet. Thanks for the effort invested though! I figured out a workaround meanwhile. I made a...

Hi Skip, the point behind it is that I have a set of machines with different setting options. In total there are 9 different criteria that the machines can possibly have. But each machine has a maximum of 4 options out of the 9. I have a table containing all settings for all machines. I would...

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 Oldnewbie, thanks for your answer! So do I interpret your answer correctly when saying that from within the loaded movie I can not find out the size of the container the movie was loaded to?

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 Kenneth, thanks for helping me out! In fact I am really having a hard time getting into AS3 but I hope your encouraging comment proves true :-) Cheers f.

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 Skip, thanks for your reply, i need this for a profit and loss statement, and the distribution of the items is used for the functionality of subsumming the line items. thanks for the comment on vba cheers

Never mind, got it solved by a colleague: Sub Macro2() Dim row As Integer row = 1 Do While row < 750 Cells(row, 3).Value = Cells(row, 1).IndentLevel row = row + 1 Loop End Sub

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

Hey Skip, thanks a ton, works like a charm! You made my day!

Hi, unfortunately this does only find exact matches, but my condition would also be fulfilled if there was a value found that is lower that the current one. If i have 1 3 4 4 2 3 and I am searching for the next value fulfilling my condition after my first "3" it would be the value "2" in row...