wolf.stalker
11-14-2011, 08:35 PM
hey all, would like some input on how to design a script. :hi:
(will include my report)
the goal of the script will be to identify each site where
1) column B = "U" and where column D does NOT have the fewest hours ( if a site has 3 rows, then the row with U must be fewest).
2) if column D does NOT have the fewest hours for all rows for that site, then all rows of that site need to go on another sheet.
3) if column D does have the fewest hours, then no action needs to be taken OR all rows for that site can be deleteled.
any one able to provide some direction on this?
(will include my report)
the goal of the script will be to identify each site where
1) column B = "U" and where column D does NOT have the fewest hours ( if a site has 3 rows, then the row with U must be fewest).
2) if column D does NOT have the fewest hours for all rows for that site, then all rows of that site need to go on another sheet.
3) if column D does have the fewest hours, then no action needs to be taken OR all rows for that site can be deleteled.
any one able to provide some direction on this?