Order base on Column

[ylafont]

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]

 

[Joe4]

Not sure why you first two Order numbers are different, when the family numbers are the same (I am assuming that it is a typo).

Assuming your Order is in column A, your Family is in column C, and the actual data starts on row 2, try this:
- Enter a 1 in cell A2
- In A3, enter thois formula and copy down for all rows

=IF(C3=C2,A2,A2+1)

 

[ylafont]

Type on my part. I should have thought about that i little harder. Thank you for eh quick response.

 

[Joe4]

You are welcome.