Hi
I like to generate Range FROM and TO Values in Column B and C from Column C as shown in below. What will be formula which will achieve same ?
Basically I want to create range for all Continuous values and create range in Column B/C
Col A Col B ColC
<colgroup><col span="3"></colgroup><tbody>
</tbody>Thanks
I like to generate Range FROM and TO Values in Column B and C from Column C as shown in below. What will be formula which will achieve same ?
Basically I want to create range for all Continuous values and create range in Column B/C
Col A Col B ColC
Company | From | To |
1000 | 1000 | |
1039 | 1039 | 1041 |
1040 | 1043 | 1044 |
1041 | 1044 | |
1043 | 1046 | |
1044 | 1053 | 1056 |
1046 | ||
1053 | ||
1054 | ||
1055 | ||
1056 | |
<colgroup><col span="3"></colgroup><tbody>
</tbody>