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.

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>

 

[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.