I have a deadline in two hours if anyone can help with this I would b
extremely grateful.

Here is an attept at psuedocode:
(Column D is sorted so all same values are next to each othe
vertically) this might help

For all col D
If col D = "Assembly"
select range in corresponding row in col G
and average the numbers that are in that range in col G
paste that average in col O row 27

Example:

Col D................ColG

Assembly............4
Assembly............2
Assembly............0
Assembly............3
Check.................1
Check.................6

I need to average the numbers in col G for all Assembly (I also need t
do the max and the stdev calculations for the same ranges.
The spreadsheet will change daily so the range will vary.

Please Help
Thank you very much

Morr

--
Message posted from http://www.ExcelForum.com