A couple of steps with Power Query.
Excel 2016 (Windows) 32 bit
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
P |
30 |
CAREER RUNS |
RUN |
WINS |
S/R% |
TOTAL RUNNERS |
RB |
%RBē |
RUNS =<2/1 |
WINS =<2/1 |
S/R% =< 2/1 |
EXP WINS |
WIV |
WAX |
TOTAL WIN SP |
SP LSP |
A/E |
31 |
1 |
11 |
5 |
45.45454545 |
15376 |
10609 |
68.9971384 |
8 |
4 |
50 |
4.008658662 |
1.247300013 |
0.991341338 |
21.08 |
10.08 |
1.247300013 |
32 |
2 |
6 |
2 |
33.33333333 |
3136 |
2025 |
64.57270408 |
2 |
1 |
50 |
1.750754148 |
1.14236485 |
0.249245852 |
5.35 |
-0.65 |
1.14236485 |
33 |
3 |
2 |
1 |
50 |
324 |
289 |
89.19753086 |
1 |
1 |
100 |
0.670168067 |
1.492163009 |
0.329831933 |
2.38 |
0.38 |
1.492163009 |
34 |
4 |
1 |
0 |
0 |
100 |
64 |
64 |
1 |
0 |
0 |
0.666666667 |
0 |
-0.666666667 |
0 |
-1 |
0 |
35 |
7 |
1 |
0 |
0 |
100 |
49 |
49 |
1 |
0 |
0 |
0.333333333 |
0 |
-0.333333333 |
0 |
-1 |
0 |
Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").
It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.
- Follow this link to learn how to install Power Query in Excel 2010 / 2013.
- Follow this link for an introduction to Power Query functionality.
- Follow this link for a video which demonstrates how to use Power Query code provided.
Bookmarks