J
Jplink49
(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
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