Thread: Managing Filtered Items

Hi
how can i apply any formula on items which are resulted because of a filter ( since filtered items are in random order )
also take a look at attachment
i need a lil vb program which could scan worksheet "Results" and column "G" ( with header "Node") and look for same text like .. for example start with "MDLH1194" it should apply the formula ( i have applied that forumula ) in front of this text ( see H2 , H15 and H65 ) to calculate duration wherever it finds "MDLH1194" text in G column .. after that it should sum up those durations as i have did ( see I2 ) and also print output like i have printed in worksheet "Analysis" (calculate minutes aswell in E2) .. ignore H233 in "Results"
and then jump over to next Node and repeat till it is done with all distinct nodes
i hope it will be a piece of cake for u gurus
waiting
Regards

Your question isn't very clear as to what exactly you want to do, but try
looking in Excel help at the subtotal worksheet function.

--
Regards,
Tom Ogilvy


"Dastard" wrote:

>
> Hi
> how can i apply any formula on items which are resulted because of a
> filter ( since filtered items are in random order )
> also take a look at attachment
> i need a lil vb program which could scan worksheet "Results" and column
> "G" ( with header "Node") and look for same text like .. for example
> start with "MDLH1194" it should apply the formula ( i have applied that
> forumula ) in front of this text ( see H2 , H15 and H65 ) to calculate
> duration wherever it finds "MDLH1194" text in G column .. after that it
> should sum up those durations as i have did ( see I2 ) and also print
> output like i have printed in worksheet "Analysis" (calculate minutes
> aswell in E2) .. ignore H233 in "Results"
> and then jump over to next Node and repeat till it is done with all
> distinct nodes
> i hope it will be a piece of cake for u gurus
> waiting
> Regards
>
>
> +-------------------------------------------------------------------+
> |Filename: Alarm-Testing.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4892 |
> +-------------------------------------------------------------------+
>
> --
> Dastard
> ------------------------------------------------------------------------
> Dastard's Profile: http://www.excelforum.com/member.php...o&userid=34406
> View this thread: http://www.excelforum.com/showthread...hreadid=552247
>
>