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.
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
Order | Date | Family | ID |
1 | 2002-02-19_08-24-10 | AATE0126004 | AATE0126004 |
2 | 2002-02-19_08-24-10 | AATE0126004 | AATE0126005 |
3 | 2002-10-22_09-15-55 | REL_0005073411 | REL_0005073411 |
3 | 2002-10-22_09-15-55 | REL_0005073411 | REL_0005073424 |
3 | 2002-10-22_09-15-55 | REL_0005073411 | REL_0005073425 |
4 | 0000-00-00_00-00-00 | MCK-HC-00008784 | MCK-HC-00008784 |
4 | 0000-00-00_00-00-00 | MCK-HC-00008784 | MCK-HC-00008785 |
5 | 0000-00-00_00-00-00 | MCK-HC-00019139 | MCK-HC-00019202 |
5 | 0000-00-00_00-00-00 | MCK-HC-00019139 | MCK-HC-00019210 |
5 | 0000-00-00_00-00-00 | MCK-HC-00019139 | MCK-HC-00019212 |
5 | 0000-00-00_00-00-00 | MCK-HC-00019139 | MCK-HC-00019222 |
5 | 0000-00-00_00-00-00 | MCK-HC-00019139 | MCK-HC-00019228 |
5 | 0000-00-00_00-00-00 | MCK-HC-00019139 | MCK-HC-00019233 |
6 | 2010-10-16 16-23-00 | REL_0000850265 | REL_0000850265 |
6 | 2010-10-16 16-23-00 | REL_0000850265 | REL_0000850267 |
7 | 2010-10-16 22-19-07 | REL_0003552712 | REL_0003552712 |
7 | 2010-10-16 22-19-07 | REL_0003552712 | REL_0003552714 |
8 | 2010-10-18 16-53-24 | REL_0000812081 | REL_0000812081 |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>