| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba: Taking average of values in one column based on a corresponding value in another column
Excel XP, Windows XP
I have dynamically changing data in columns E and F that start at row 10 and continue down, I would like to be able to accomplish the following using vba: 1) Take the average of all the data in E that has a corresponding value (say, 24) in F and then enter that average in column G. 2) Find the last cell in F that contains 24 and enter its corresponding value from E in column G. Any help is greatly appreciated, as I am stuck in the mud when it comes to vba. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| Based on data in previous column - sum of values in next column | Excel Worksheet Functions | |||
| How to average values based on a condition in another column | Excel Worksheet Functions | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
