Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
(Urgent) If col D= value, avg col G
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) | |||
Can anybody help please? Urgent | Excel Programming | |||
Macro help urgent urgent | Excel Programming | |||
Macro help urgent urgent | Excel Programming |