VBA code to find specific data by name. Get average. Put in cell.
You don't need a macro to do this calculation.
Try this:
In G2, put this
=average(if(C3:C8=F2,D3:D8))
Commit with CTRL SHIFT ENTER
--
HTH,
Barb Reinhardt
"Jplink49" wrote:
(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
|