Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to find specific data by name. Get average. Put in cell.
(See Sheet Below)I need code that would find the name in C column and get the
Test Result associated with that name in the D column. Do this each time it sees that name, average the results, and place that result in another specific cell. For example!!, find each PPerson in range C:2 to C:8 and get corresponding Result in the D column. C:4--* 98.7 C:6--* 99.5 C:7--* 99.7 B C D E F G H 1 Date Analyst Results Analyst Avg. Coun 2 EJackson 98.4 2 3 3/20/08 EJackson 99.2 PPerson 99.3 3 4 3/20/08 PPerson 98.7 MSilverton 99.2 1 5 3/20/08 MSilveton 99.2 6 3/20/08 PPerson 99.5 7 3/20/08 PPerson 99.7 8 3/20/08 EJackson 97.6 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i find specific data in a cell and its colocated cell data | Excel Worksheet Functions | |||
code to go down a column and find the last cell with data before an empty cell | Excel Programming | |||
Macro to find specific data in a cell, then delete that row on down | Excel Programming | |||
UDF code to find specific text in cell comments, then average cell values | Excel Programming | |||
how do I find an average number of specific words in a column | New Users to Excel |