Hi All,
I have values in column L such as the following:
400,000
300,300
1,230,340
I want to group these into certain bands within Column M, the band are listed within a separate tab called "Bands" and the options are as follows - how can I code this? I fear the word "Euro" could cause problems?
<tbody>
</tbody><colgroup><col></colgroup>
I have values in column L such as the following:
400,000
300,300
1,230,340
I want to group these into certain bands within Column M, the band are listed within a separate tab called "Bands" and the options are as follows - how can I code this? I fear the word "Euro" could cause problems?
01 000 000 to below 01 500 000 Euro |
01 500 000 to below 02 000 000 Euro |
02 000 000 to below 02 500 000 Euro |
02 500 000 to below 03 000 000 Euro |
03 000 000 to below 03 500 000 Euro |
03 500 000 to below 04 000 000 Euro |
04 000 000 to below 04 500 000 Euro |
04 500 000 to below 05 000 000 Euro |
05 000 000 to below 06 000 000 Euro |
06 000 000 to below 07 000 000 Euro |
07 000 000 to below 08 000 000 Euro |
08 000 000 to below 09 000 000 Euro |
11 000 000 to below 12 000 000 Euro |
13 000 000 to below 14 000 000 Euro |
below 01 000 000 Euro |
<tbody>
</tbody><colgroup><col></colgroup>