Results 1 to 5 of 5

Thread: Managing Filtered Items

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 2005
    Location
    Lahore
    Posts
    214

    Arrow 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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width