I'm having a difficult day already and I can't seem to think of a formula for this. In one column I have a set of numbers in one column (far left) and in the other dates. What I need is to create a formula to have a number sequence of 1,2,3 but changing with each new number in the far left column:
0000010910 05/04/2014 5/31/2015
0000010910 05/05/2013 5/3/2014
0000011270 05/04/2014 5/31/2015
0000011270 07/15/2013 5/3/2014
0000011280 05/04/2014 5/31/2015
0000011280 07/15/2013 5/3/2014
0000011290 05/04/2014 5/31/2015
0000011290 07/15/2013 5/3/2014
0000011300 05/04/2014 5/31/2015
0000011300 07/15/2013 5/3/2014
0000011310 05/04/2014 5/31/2015
0000011310 07/15/2013 5/3/2014
0000011320 05/04/2014 5/31/2015
0000011320 07/15/2013 5/3/2014
0000011330 05/04/2014 5/31/2015
0000011330 07/15/2013 5/3/2014
0000011340 05/04/2014 5/31/2015
0000011340 07/15/2013 5/3/2014
0000011350 05/04/2014 5/31/2015
0000011350 07/15/2013 5/3/2014
0000011360 05/04/2014 5/31/2015
0000011360 07/15/2013 5/3/2014
0000011370 05/04/2014 5/31/2015
0000011370 07/15/2013 5/3/2014
0000011380 05/04/2014 5/31/2015
0000011380 07/15/2013 5/3/2014
0000011390 05/04/2014 5/31/2015
0000011390 07/15/2013 5/3/2014
0000011400 05/04/2014 5/31/2015
If you can help that would be great. Thanks