JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,540
- Office Version
- 365
- Platform
- Windows
I would like to save the data from this graph in an Excel table.
But Excel keeps adding suffixes to make the headers unique.
The best solution I could think of is to put spaces around the "duplicate" headers.
Is there a better way?
But Excel keeps adding suffixes to make the headers unique.
EBikes.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
4 | Bicyclist Deaths by Helmet Use | |||||||||||
5 | No Helmet | Helmeted | Unknown | Total | ||||||||
6 | Year | # | % | #2 | %2 | #3 | %3 | #4 | %4 | Ratio | ||
7 | 1994 | 776 | 97 | 19 | 2 | 1 | 0 | 796 | 100 | 48.5 | ||
8 | 1995 | 783 | 95 | 34 | 4 | 11 | 1 | 828 | 100 | 23.8 | ||
9 | 1996 | 731 | 96 | 27 | 4 | 3 | 0 | 761 | 100 | 24.0 | ||
10 | 1997 | 785 | 97 | 23 | 3 | 3 | 0 | 811 | 100 | 32.3 | ||
11 | 1998 | 741 | 98 | 16 | 2 | 0 | 0 | 757 | 100 | 49.0 | ||
Helmet v No Helmet |
Cell Formulas | ||
---|---|---|
Range | Formula | |
K7:K11 | K7 | =[@[%]]/[@[%2]] |
The best solution I could think of is to put spaces around the "duplicate" headers.
EBikes.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
4 | Bicyclist Deaths by Helmet Use | |||||||||||
5 | No Helmet | Helmeted | Unknown | Total | ||||||||
6 | Year | # | % | # | % | # | % | # | % | Ratio | ||
7 | 1994 | 776 | 97 | 19 | 2 | 1 | 0 | 796 | 100 | 48.5 | ||
8 | 1995 | 783 | 95 | 34 | 4 | 11 | 1 | 828 | 100 | 23.8 | ||
9 | 1996 | 731 | 96 | 27 | 4 | 3 | 0 | 761 | 100 | 24.0 | ||
10 | 1997 | 785 | 97 | 23 | 3 | 3 | 0 | 811 | 100 | 32.3 | ||
11 | 1998 | 741 | 98 | 16 | 2 | 0 | 0 | 757 | 100 | 49.0 | ||
Helmet v No Helmet |
Cell Formulas | ||
---|---|---|
Range | Formula | |
K7:K11 | K7 | =[@[%]]/[@[ % ]] |
Is there a better way?