Hi, I have a set of data like this
[TABLE="width: 223"]
<tbody>[TR]
[TD]AAA[/TD]
[TD]2-May-20[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]18-Jun-20[/TD]
[/TR]
[TR]
[TD]CCC[/TD]
[TD]29-Mar-20[/TD]
[/TR]
[TR]
[TD]DDD[/TD]
[TD]9-Feb-21[/TD]
[/TR]
[TR]
[TD]EEE[/TD]
[TD]9-Feb-22[/TD]
[/TR]
[TR]
[TD]FFF[/TD]
[TD]9-Feb-20[/TD]
[/TR]
[TR]
[TD]GGG[/TD]
[TD]9-Feb-23[/TD]
[/TR]
[TR]
[TD]HHH[/TD]
[TD]9-Feb-20[/TD]
[/TR]
[TR]
[TD]JJJ[/TD]
[TD]27-Feb-28[/TD]
[/TR]
[TR]
[TD]KKK[/TD]
[TD]2-Jan-27[/TD]
[/TR]
[TR]
[TD]MMM[/TD]
[TD]14-Oct-21[/TD]
[/TR]
[TR]
[TD]NNN[/TD]
[TD]15-Oct-19[/TD]
[/TR]
</tbody>[/TABLE]
I want to sort it like this
[TABLE="width: 304"]
<tbody>[TR]
[TD]Before 2020[/TD]
[TD]Between 2020-2022[/TD]
[TD]2023 and after[/TD]
[/TR]
[TR]
[TD]NNN[/TD]
[TD]FFF[/TD]
[TD]GGG[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]HHH[/TD]
[TD]KKK[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]CCC[/TD]
[TD]JJJ[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AAA[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]BBB[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DDD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MMM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]EEE[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any formula to do that?
Regards
Soumen
[TABLE="width: 223"]
<tbody>[TR]
[TD]AAA[/TD]
[TD]2-May-20[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]18-Jun-20[/TD]
[/TR]
[TR]
[TD]CCC[/TD]
[TD]29-Mar-20[/TD]
[/TR]
[TR]
[TD]DDD[/TD]
[TD]9-Feb-21[/TD]
[/TR]
[TR]
[TD]EEE[/TD]
[TD]9-Feb-22[/TD]
[/TR]
[TR]
[TD]FFF[/TD]
[TD]9-Feb-20[/TD]
[/TR]
[TR]
[TD]GGG[/TD]
[TD]9-Feb-23[/TD]
[/TR]
[TR]
[TD]HHH[/TD]
[TD]9-Feb-20[/TD]
[/TR]
[TR]
[TD]JJJ[/TD]
[TD]27-Feb-28[/TD]
[/TR]
[TR]
[TD]KKK[/TD]
[TD]2-Jan-27[/TD]
[/TR]
[TR]
[TD]MMM[/TD]
[TD]14-Oct-21[/TD]
[/TR]
[TR]
[TD]NNN[/TD]
[TD]15-Oct-19[/TD]
[/TR]
</tbody>[/TABLE]
I want to sort it like this
[TABLE="width: 304"]
<tbody>[TR]
[TD]Before 2020[/TD]
[TD]Between 2020-2022[/TD]
[TD]2023 and after[/TD]
[/TR]
[TR]
[TD]NNN[/TD]
[TD]FFF[/TD]
[TD]GGG[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]HHH[/TD]
[TD]KKK[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]CCC[/TD]
[TD]JJJ[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AAA[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]BBB[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DDD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MMM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]EEE[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any formula to do that?
Regards
Soumen
Last edited: