Michael515
Board Regular
- Joined
- Jul 10, 2014
- Messages
- 136
So I have on the X-axis Pitching Distances.
On the Y-axis Velocities.
And in the table is the corresponding reaction times.
If I have the reaction time and the distance, how do I create a formula to find the row. (I know how to use Index Match to find the intersection of the Pitching Distances and the Velocities, but not how to find the Row based off the value and Distance).
<colgroup><col><col><col span="21"></colgroup><tbody>
</tbody>
Thank you for whoever can help.
On the Y-axis Velocities.
And in the table is the corresponding reaction times.
If I have the reaction time and the distance, how do I create a formula to find the row. (I know how to use Index Match to find the intersection of the Pitching Distances and the Velocities, but not how to find the Row based off the value and Distance).
Reaction Time | Distance | |||||||||||||||||||||
40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | ||
Recorded Velocity | 60 | 0.45 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.55 | 0.56 | 0.57 | 0.58 | 0.59 | 0.60 | 0.61 | 0.63 | 0.64 | 0.65 | 0.66 | 0.67 | 0.68 |
61 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | 0.59 | 0.60 | 0.61 | 0.63 | 0.64 | 0.65 | 0.66 | 0.67 | |
62 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | 0.59 | 0.60 | 0.62 | 0.63 | 0.64 | 0.65 | 0.66 | |
63 | 0.43 | 0.44 | 0.45 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | 0.60 | 0.61 | 0.62 | 0.63 | 0.64 | 0.65 | |
64 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.58 | 0.59 | 0.60 | 0.61 | 0.62 | 0.63 | 0.64 | |
65 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.55 | 0.56 | 0.57 | 0.58 | 0.59 | 0.60 | 0.61 | 0.62 | 0.63 | |
66 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | 0.59 | 0.60 | 0.61 | 0.62 | |
67 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | 0.59 | 0.60 | 0.61 | |
68 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | 0.59 | 0.60 | |
69 | 0.40 | 0.41 | 0.42 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | 0.59 | |
70 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.56 | 0.57 | 0.58 | |
71 | 0.38 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | |
72 | 0.38 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | |
73 | 0.37 | 0.38 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | |
74 | 0.37 | 0.38 | 0.39 | 0.40 | 0.41 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.53 | 0.54 | 0.55 | |
75 | 0.36 | 0.37 | 0.38 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | |
76 | 0.36 | 0.37 | 0.38 | 0.39 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.53 | 0.54 | |
77 | 0.35 | 0.36 | 0.37 | 0.38 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.50 | 0.51 | 0.52 | 0.53 | |
78 | 0.35 | 0.36 | 0.37 | 0.38 | 0.38 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | 0.52 | |
79 | 0.35 | 0.35 | 0.36 | 0.37 | 0.38 | 0.39 | 0.40 | 0.41 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | 0.52 | |
80 | 0.34 | 0.35 | 0.36 | 0.37 | 0.38 | 0.38 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.49 | 0.50 | 0.51 | |
81 | 0.34 | 0.35 | 0.35 | 0.36 | 0.37 | 0.38 | 0.39 | 0.40 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.50 | 0.51 | |
82 | 0.33 | 0.34 | 0.35 | 0.36 | 0.37 | 0.37 | 0.38 | 0.39 | 0.40 | 0.41 | 0.42 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.47 | 0.48 | 0.49 | 0.50 | |
83 | 0.33 | 0.34 | 0.35 | 0.35 | 0.36 | 0.37 | 0.38 | 0.39 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.48 | 0.49 | |
84 | 0.32 | 0.33 | 0.34 | 0.35 | 0.36 | 0.37 | 0.37 | 0.38 | 0.39 | 0.40 | 0.41 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | |
85 | 0.32 | 0.33 | 0.34 | 0.34 | 0.35 | 0.36 | 0.37 | 0.38 | 0.39 | 0.39 | 0.40 | 0.41 | 0.42 | 0.43 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.47 | 0.48 | |
86 | 0.32 | 0.33 | 0.33 | 0.34 | 0.35 | 0.36 | 0.36 | 0.37 | 0.38 | 0.39 | 0.40 | 0.40 | 0.41 | 0.42 | 0.43 | 0.44 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | |
87 | 0.31 | 0.32 | 0.33 | 0.34 | 0.34 | 0.35 | 0.36 | 0.37 | 0.38 | 0.38 | 0.39 | 0.40 | 0.41 | 0.42 | 0.42 | 0.43 | 0.44 | 0.45 | 0.45 | 0.46 | 0.47 | |
88 | 0.31 | 0.32 | 0.33 | 0.33 | 0.34 | 0.35 | 0.36 | 0.36 | 0.37 | 0.38 | 0.39 | 0.40 | 0.40 | 0.41 | 0.42 | 0.43 | 0.43 | 0.44 | 0.45 | 0.46 | 0.46 | |
89 | 0.31 | 0.31 | 0.32 | 0.33 | 0.34 | 0.34 | 0.35 | 0.36 | 0.37 | 0.38 | 0.38 | 0.39 | 0.40 | 0.41 | 0.41 | 0.42 | 0.43 | 0.44 | 0.44 | 0.45 | 0.46 | |
90 | 0.30 | 0.31 | 0.32 | 0.33 | 0.33 | 0.34 | 0.35 | 0.36 | 0.36 | 0.37 | 0.38 | 0.39 | 0.39 | 0.40 | 0.41 | 0.42 | 0.42 | 0.43 | 0.44 | 0.45 | 0.45 | |
91 | 0.30 | 0.31 | 0.31 | 0.32 | 0.33 | 0.34 | 0.34 | 0.35 | 0.36 | 0.37 | 0.37 | 0.38 | 0.39 | 0.40 | 0.40 | 0.41 | 0.42 | 0.43 | 0.43 | 0.44 | 0.45 | |
92 | 0.30 | 0.30 | 0.31 | 0.32 | 0.33 | 0.33 | 0.34 | 0.35 | 0.36 | 0.36 | 0.37 | 0.38 | 0.39 | 0.39 | 0.40 | 0.41 | 0.42 | 0.42 | 0.43 | 0.44 | 0.44 | |
93 | 0.29 | 0.30 | 0.31 | 0.32 | 0.32 | 0.33 | 0.34 | 0.34 | 0.35 | 0.36 | 0.37 | 0.37 | 0.38 | 0.39 | 0.40 | 0.40 | 0.41 | 0.42 | 0.43 | 0.43 | 0.44 | |
94 | 0.29 | 0.30 | 0.30 | 0.31 | 0.32 | 0.33 | 0.33 | 0.34 | 0.35 | 0.36 | 0.36 | 0.37 | 0.38 | 0.38 | 0.39 | 0.40 | 0.41 | 0.41 | 0.42 | 0.43 | 0.44 | |
95 | 0.29 | 0.29 | 0.30 | 0.31 | 0.32 | 0.32 | 0.33 | 0.34 | 0.34 | 0.35 | 0.36 | 0.37 | 0.37 | 0.38 | 0.39 | 0.39 | 0.40 | 0.41 | 0.42 | 0.42 | 0.43 | |
96 | 0.28 | 0.29 | 0.30 | 0.31 | 0.31 | 0.32 | 0.33 | 0.33 | 0.34 | 0.35 | 0.36 | 0.36 | 0.37 | 0.38 | 0.38 | 0.39 | 0.40 | 0.40 | 0.41 | 0.42 | 0.43 | |
97 | 0.28 | 0.29 | 0.30 | 0.30 | 0.31 | 0.32 | 0.32 | 0.33 | 0.34 | 0.34 | 0.35 | 0.36 | 0.37 | 0.37 | 0.38 | 0.39 | 0.39 | 0.40 | 0.41 | 0.41 | 0.42 | |
98 | 0.28 | 0.29 | 0.29 | 0.30 | 0.31 | 0.31 | 0.32 | 0.33 | 0.33 | 0.34 | 0.35 | 0.35 | 0.36 | 0.37 | 0.38 | 0.38 | 0.39 | 0.40 | 0.40 | 0.41 | 0.42 | |
99 | 0.28 | 0.28 | 0.29 | 0.30 | 0.30 | 0.31 | 0.32 | 0.32 | 0.33 | 0.34 | 0.34 | 0.35 | 0.36 | 0.37 | 0.37 | 0.38 | 0.39 | 0.39 | 0.40 | 0.41 | 0.41 | |
100 | 0.27 | 0.28 | 0.29 | 0.29 | 0.30 | 0.31 | 0.31 | 0.32 | 0.33 | 0.33 | 0.34 | 0.35 | 0.35 | 0.36 | 0.37 | 0.38 | 0.38 | 0.39 | 0.40 | 0.40 | 0.41 |
<colgroup><col><col><col span="21"></colgroup><tbody>
</tbody>
Thank you for whoever can help.