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


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

Managing Filtered Items
 

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