Hi,
I have a set of data as shown below
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I want to sort it this way
<colgroup><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Any formulas to use for sorting this way. Please help.
Regards
I have a set of data as shown below
Value | Category | Date |
Red | A | 3-Jun-19 |
Yellow | B | 8-Aug-22 |
Blue | C | 10-Jun-20 |
Green | A | 12-Dec-19 |
Black | B | 12-Dec-21 |
Purple | C | 5-Jul-23 |
Pink | A | 30-Dec-20 |
Brown | A | 21-Nov-20 |
Magenta | B | 5-Mar-19 |
Orange | A | 24-Jul-23 |
Lime | A | 13-Feb-28 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I want to sort it this way
Enter Category | <A> | Before 2020 | Between 2020-2022 | After 2023 | |||
Value | Date | Value | Date | Value | Date | ||
Red | 3-Jun-19 | Brown | 21-Nov-20 | Orange | 24-Jul-23 | ||
Green | 12-Dec-19 | Pink | 30-Dec-20 | Lime | 13-Feb-28 |
<colgroup><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Any formulas to use for sorting this way. Please help.
Regards