Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic count for filtered items | Excel Discussion (Misc queries) | |||
items filtered | Excel Discussion (Misc queries) | |||
Highlite filtered items | Excel Programming | |||
cut and paste filtered items | Excel Discussion (Misc queries) | |||
counting filtered items | Excel Worksheet Functions |