Can anyone let me know what formula i can use to create an order based on a column? The example below uses the Family column to order the sets in number sequence (order column) and increment by 1 each time the number changes. Than you in advance, much appreciated.
[TABLE="width: 540"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Order[/TD]
[TD]Date[/TD]
[TD]Family[/TD]
[TD]ID[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2002-02-19_08-24-10[/TD]
[TD]AATE0126004[/TD]
[TD]AATE0126004[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2002-02-19_08-24-10[/TD]
[TD]AATE0126004[/TD]
[TD]AATE0126005[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2002-10-22_09-15-55[/TD]
[TD]REL_0005073411[/TD]
[TD]REL_0005073411[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2002-10-22_09-15-55[/TD]
[TD]REL_0005073411[/TD]
[TD]REL_0005073424[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2002-10-22_09-15-55[/TD]
[TD]REL_0005073411[/TD]
[TD]REL_0005073425[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00008784[/TD]
[TD]MCK-HC-00008784[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00008784[/TD]
[TD]MCK-HC-00008785[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019202[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019210[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019212[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019222[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019228[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019233[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2010-10-16 16-23-00[/TD]
[TD]REL_0000850265[/TD]
[TD]REL_0000850265[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2010-10-16 16-23-00[/TD]
[TD]REL_0000850265[/TD]
[TD]REL_0000850267[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2010-10-16 22-19-07[/TD]
[TD]REL_0003552712[/TD]
[TD]REL_0003552712[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2010-10-16 22-19-07[/TD]
[TD]REL_0003552712[/TD]
[TD]REL_0003552714[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2010-10-18 16-53-24[/TD]
[TD]REL_0000812081[/TD]
[TD]REL_0000812081[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 540"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Order[/TD]
[TD]Date[/TD]
[TD]Family[/TD]
[TD]ID[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2002-02-19_08-24-10[/TD]
[TD]AATE0126004[/TD]
[TD]AATE0126004[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2002-02-19_08-24-10[/TD]
[TD]AATE0126004[/TD]
[TD]AATE0126005[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2002-10-22_09-15-55[/TD]
[TD]REL_0005073411[/TD]
[TD]REL_0005073411[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2002-10-22_09-15-55[/TD]
[TD]REL_0005073411[/TD]
[TD]REL_0005073424[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2002-10-22_09-15-55[/TD]
[TD]REL_0005073411[/TD]
[TD]REL_0005073425[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00008784[/TD]
[TD]MCK-HC-00008784[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00008784[/TD]
[TD]MCK-HC-00008785[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019202[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019210[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019212[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019222[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019228[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0000-00-00_00-00-00[/TD]
[TD]MCK-HC-00019139[/TD]
[TD]MCK-HC-00019233[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2010-10-16 16-23-00[/TD]
[TD]REL_0000850265[/TD]
[TD]REL_0000850265[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2010-10-16 16-23-00[/TD]
[TD]REL_0000850265[/TD]
[TD]REL_0000850267[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2010-10-16 22-19-07[/TD]
[TD]REL_0003552712[/TD]
[TD]REL_0003552712[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2010-10-16 22-19-07[/TD]
[TD]REL_0003552712[/TD]
[TD]REL_0003552714[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2010-10-18 16-53-24[/TD]
[TD]REL_0000812081[/TD]
[TD]REL_0000812081[/TD]
[/TR]
</tbody>[/TABLE]