This may be very simple, but I can not find a way to easily do this. I can export all the data needed, but I want to be able to quickly view just the rows that are needed.
For example I will use baseball stats Below:
This Exported sheet includes a list Every Single baseball player however I only want to view the rows of A.J Pollock, Aaron Altherr and so on... Is there a easy way to find or a formula to select multiple people by name in one step. right now I am searching one at a time.
Hopefully this makes sense. Thanks in advance for the help
<colgroup><col width="151" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5522;"> <col width="64" style="width: 48pt;" span="14"> <tbody>
</tbody>
For example I will use baseball stats Below:
This Exported sheet includes a list Every Single baseball player however I only want to view the rows of A.J Pollock, Aaron Altherr and so on... Is there a easy way to find or a formula to select multiple people by name in one step. right now I am searching one at a time.
Hopefully this makes sense. Thanks in advance for the help
Name | Team | G | AB | H | HR | R | RBI | SB | AVG | OBP | OPS | wRC+ | BsR | ADP |
A.J. Jimenez | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.221 | 0.263 | 0.597 | 55 | 0 | 999 | |
A.J. Murray | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.192 | 0.244 | 0.534 | 39 | 0 | 999 | |
A.J. Pierzynski | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.247 | 0.287 | 0.65 | 70 | 0 | 999 | |
A.J. Pollock | Diamondbacks | 124 | 499 | 141 | 18 | 81 | 62 | 22 | 0.282 | 0.346 | 0.821 | 109 | 1.2 | 63.6 |
A.J. Reed | Astros | 30 | 104 | 23 | 5 | 14 | 15 | 0 | 0.223 | 0.304 | 0.711 | 92 | 0 | 628.7 |
A.J. Simcox | Tigers | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.245 | 0.282 | 0.628 | 63 | 0 | 999 |
Aaron Altherr | Phillies | 109 | 403 | 101 | 18 | 54 | 59 | 8 | 0.25 | 0.324 | 0.774 | 100 | -0.6 | 260.8 |
Aaron Arruda | Athletics | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.154 | 0.187 | 0.422 | 8 | 0 | 999 |
Aaron Attaway | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.189 | 0.236 | 0.494 | 29 | 0 | 999 |
<colgroup><col width="151" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5522;"> <col width="64" style="width: 48pt;" span="14"> <tbody>
</tbody>