Estatefinds
Board Regular
- Joined
- Sep 14, 2015
- Messages
- 169
So for the following data: The individual numbers are in columns BB Through BF.
so I need a macro to list the remaining uncolored numbers data but instead of the number itself listed it would be the position in which it sits. so the first example will show the numbers and the second example will show the positions. and place the list in column AN on the same row its starts reading data at from top to bottom. Please! Thank you
<tbody>
</tbody>
second example:
<tbody>
</tbody>
so I need a macro to list the remaining uncolored numbers data but instead of the number itself listed it would be the position in which it sits. so the first example will show the numbers and the second example will show the positions. and place the list in column AN on the same row its starts reading data at from top to bottom. Please! Thank you
3 | 8 | 13 | 14 | 26 |
3 | 8 | 13 | 27 | 28 |
1 | 24 | 27 | 28 | 30 |
5 | 10 | 12 | 24 | 33 |
4 | 14 | 15 | 17 | 31 |
2 | 11 | 18 | 19 | 22 |
7 | 17 | 18 | 26 | 28 |
5 | 15 | 19 | 32 | 34 |
6 | 9 | 16 | 26 | 34 |
9 | 14 | 22 | 30 | 33 |
10 | 18 | 24 | 31 | 35 |
4 | 18 | 19 | 27 | 31 |
2 | 4 | 20 | 24 | 33 |
20 | 25 | 27 | 29 | 32 |
4 | 17 | 25 | 26 | 30 |
13 | 15 | 18 | 20 | 35 |
3 | 7 | 13 | 26 | 33 |
10 | 21 | 24 | 28 | 34 |
12 | 18 | 25 | 28 | 34 |
3 | 15 | 25 | 27 | 29 |
2 | 8 | 9 | 21 | 31 |
10 | 12 | 17 | 30 | 33 |
2 | 8 | 13 | 17 | 32 |
3 | 8 | 18 | 25 | 33 |
2 | 4 | 8 | 33 | 34 |
2 | 5 | 16 | 21 | 23 |
4 | 5 | 22 | 23 | 24 |
3 | 22 | 25 | 26 | 33 |
7 | 11 | 16 | 19 | 28 |
2 | 13 | 18 | 31 | 33 |
3 | 6 | 10 | 18 | 23 |
8 | 13 | 16 | 21 | 33 |
9 | 12 | 23 | 27 | 35 |
6 | 23 | 25 | 27 | 30 |
4 | 6 | 27 | 28 | 32 |
12 | 20 | 22 | 27 | 30 |
9 | 17 | 21 | 22 | 35 |
1 | 3 | 8 | 16 | 32 |
3 | 4 | 9 | 27 | 28 |
15 | 16 | 24 | 25 | 27 |
5 | 22 | 26 | 30 | 32 |
4 | 7 | 10 | 16 | 20 |
3 | 10 | 16 | 20 | 32 |
4 | 10 | 25 | 27 | 35 |
6 | 17 | 19 | 28 | 29 |
6 | 11 | 12 | 16 | 25 |
1 | 3 | 9 | 25 | 28 |
6 | 11 | 16 | 22 | 25 |
1 | 7 | 14 | 17 | 22 |
15 | 22 | 24 | 31 | 32 |
3 | 5 | 17 | 23 | 29 |
15 | 16 | 23 | 25 | 28 |
1 | 8 | 9 | 21 | 24 |
14 | 21 | 22 | 32 | 33 |
7 | 14 | 17 | 25 | 29 |
6 | 14 | 22 | 30 | 33 |
10 | 20 | 23 | 28 | 33 |
6 | 9 | 10 | 16 | 27 |
1 | 9 | 20 | 27 | 30 |
1 | 2 | 10 | 18 | 20 |
8 | 19 | 23 | 29 | 33 |
9 | 18 | 19 | 29 | 33 |
15 | 18 | 19 | 22 | 26 |
6 | 18 | 20 | 27 | 35 |
8 | 13 | 23 | 28 | 34 |
5 | 15 | 23 | 34 | 35 |
6 | 13 | 24 | 28 | 29 |
1 | 7 | 27 | 30 | 35 |
1 | 5 | 7 | 18 | 31 |
9 | 12 | 16 | 18 | 35 |
<tbody>
</tbody>
second example:
A1 | B1 | C1 | D1 | E1 |
A2 | B2 | C2 | D2 | E2 |
A3 | B3 | C3 | D3 | E3 |
A4 | B4 | C4 | D4 | E4 |
A5 | B5 | C5 | D5 | E5 |
A6 | B6 | C6 | D6 | E6 |
A7 | B7 | C7 | D7 | E7 |
A8 | B8 | C8 | D8 | E8 |
A9 | B9 | C9 | D9 | E9 |
A10 | B10 | C10 | D10 | E10 |
A11 | B11 | C11 | D11 | E11 |
A12 | B12 | C12 | D12 | E12 |
A13 | B13 | C13 | D13 | E13 |
A14 | B14 | C14 | D14 | E14 |
A15 | B15 | C15 | D15 | E15 |
A16 | B16 | C16 | D16 | E16 |
A17 | B17 | C17 | D17 | E17 |
A18 | B18 | C18 | D18 | E18 |
A19 | B19 | C19 | D19 | E19 |
A20 | B20 | C20 | D20 | E20 |
A21 | B21 | C21 | D21 | E21 |
A22 | B22 | C22 | D22 | E22 |
A23 | B23 | C23 | D23 | E23 |
A24 | B24 | C24 | D24 | E24 |
A25 | B25 | C25 | D25 | E25 |
A26 | B26 | C26 | D26 | E26 |
A27 | B27 | C27 | D27 | E27 |
A28 | B28 | C28 | D28 | E28 |
A29 | B29 | C29 | D29 | E29 |
A30 | B30 | C30 | D30 | E30 |
A31 | B31 | C31 | D31 | E31 |
A32 | B32 | C32 | D32 | E32 |
A33 | B33 | C33 | D33 | E33 |
A34 | B34 | C34 | D34 | E34 |
A35 | B35 | C35 | D35 | E35 |
A36 | B36 | C36 | D36 | E36 |
A37 | B37 | C37 | D37 | E37 |
A38 | B38 | C38 | D38 | E38 |
A39 | B39 | C39 | D39 | E39 |
A40 | B40 | C40 | D40 | E40 |
A41 | B41 | C41 | D41 | E41 |
A42 | B42 | C42 | D42 | E42 |
A43 | B43 | C43 | D43 | E43 |
A44 | B44 | C44 | D44 | E44 |
A45 | B45 | C45 | D45 | E45 |
A46 | B46 | C46 | D46 | E46 |
A47 | B47 | C47 | D47 | E47 |
A48 | B48 | C48 | D48 | E48 |
A49 | B49 | C49 | D49 | E49 |
A50 | B50 | C50 | D50 | E50 |
A51 | B51 | C51 | D51 | E51 |
A52 | B52 | C52 | D52 | E52 |
A53 | B53 | C53 | D53 | E53 |
A54 | B54 | C54 | D54 | E54 |
A55 | B55 | C55 | D55 | E55 |
A56 | B56 | C56 | D56 | E56 |
A57 | B57 | C57 | D57 | E57 |
A58 | B58 | C58 | D58 | E58 |
A59 | B59 | C59 | D59 | E59 |
A60 | B60 | C60 | D60 | E60 |
A61 | B61 | C61 | D61 | E61 |
A62 | B62 | C62 | D62 | E62 |
A63 | B63 | C63 | D63 | E63 |
A64 | B64 | C64 | D64 | E64 |
A65 | B65 | C65 | D65 | E65 |
A66 | B66 | C66 | D66 | E66 |
A67 | B67 | C67 | D67 | E67 |
A68 | B68 | C68 | D68 | E68 |
A69 | B69 | C69 | D69 | E69 |
A70 | B70 | C70 | D70 | E70 |
<tbody>
</tbody>
Last edited: