I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as
the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
For example, if you have Excel 365 and want multiple columns returned you can do so with one single simple formula entered in one cell.
bhalbach.xlsm |
---|
|
---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U |
---|
1 | Hdr1 | Hdr2 | Hdr3 | Hdr4 | Hdr5 | Hdr6 | Hdr7 | Hdr8 | Hdr9 | Hdr10 | Hdr11 | Hdr12 | Hdr13 | Hdr14 | Hdr15 | Hdr16 | Hdr17 | Hdr18 | Dates | Hdr20 | Hdr21 |
---|
2 | 90 | 57 | 38 | 77 | 77 | 22 | 19 | 4 | 37 | 67 | 26 | 80 | 13 | 26 | 33 | 82 | 49 | 19 | 1/01/2020 | 5 | 7 |
---|
3 | 30 | 80 | 38 | 43 | 8 | 92 | 99 | 33 | 52 | 12 | 88 | 95 | 93 | 41 | 48 | 86 | 10 | 54 | 3/03/2020 | 89 | 72 |
---|
4 | 75 | 74 | 53 | 65 | 91 | 8 | 99 | 55 | 99 | 79 | 14 | 71 | 15 | 84 | 16 | 44 | 73 | 69 | 4/04/2020 | 29 | 11 |
---|
5 | 29 | 37 | 16 | 97 | 37 | 36 | 98 | 44 | 91 | 79 | 15 | 27 | 63 | 16 | 69 | 99 | 39 | 8 | 5/05/2020 | 64 | 53 |
---|
6 | 9 | 37 | 2 | 39 | 82 | 96 | 52 | 42 | 59 | 51 | 54 | 34 | 15 | 43 | 65 | 51 | 24 | 22 | 6/06/2020 | 95 | 74 |
---|
7 | 34 | 46 | 54 | 35 | 31 | 45 | 88 | 6 | 54 | 82 | 24 | 14 | 26 | 23 | 11 | 38 | 90 | 32 | 7/07/2020 | 12 | 18 |
---|
|
---|
bhalbach.xlsm |
---|
|
---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U |
---|
1 | 4/04/2020 | | | | | | | | | | | | | | | | | | | | |
---|
2 | Hdr1 | Hdr2 | Hdr3 | Hdr4 | Hdr5 | Hdr6 | Hdr7 | Hdr8 | Hdr9 | Hdr10 | Hdr11 | Hdr12 | Hdr13 | Hdr14 | Hdr15 | Hdr16 | Hdr17 | Hdr18 | Dates | Hdr20 | Hdr21 |
---|
3 | 75 | 74 | 53 | 65 | 91 | 8 | 99 | 55 | 99 | 79 | 14 | 71 | 15 | 84 | 16 | 44 | 73 | 69 | 4/04/2020 | 29 | 11 |
---|
4 | 29 | 37 | 16 | 97 | 37 | 36 | 98 | 44 | 91 | 79 | 15 | 27 | 63 | 16 | 69 | 99 | 39 | 8 | 5/05/2020 | 64 | 53 |
---|
5 | 9 | 37 | 2 | 39 | 82 | 96 | 52 | 42 | 59 | 51 | 54 | 34 | 15 | 43 | 65 | 51 | 24 | 22 | 6/06/2020 | 95 | 74 |
---|
6 | 34 | 46 | 54 | 35 | 31 | 45 | 88 | 6 | 54 | 82 | 24 | 14 | 26 | 23 | 11 | 38 | 90 | 32 | 7/07/2020 | 12 | 18 |
---|
|
---|