D
Donna
Col A COL B Col C
DATES TRANS ADJ
4/06/07 A 1
4/07/09 C
4/06/07 A 1
4/25/09 C
4/03/09 A 2
4/09/02 C
4/25/09 C
4/03/09 A 2
In C I have put what I would want it to be. If column B = "A" then I
would want the dates that match to be numbered in sequence , so as the 1's
above they both have a date of 4/06/07 so anything that had that date would
be 1, then the next one that is "A" is 4/03/09 any of those dates that have
a "A" in column B then all the corresponding dates would be number 2, and
so on. Also the adjustments are not in order as mine are above, one A with a
corresponding date may be in several lines throughout the column . I hope I
have explained what I need. Thanks in advance for looking at this for
me. Donna
DATES TRANS ADJ
4/06/07 A 1
4/07/09 C
4/06/07 A 1
4/25/09 C
4/03/09 A 2
4/09/02 C
4/25/09 C
4/03/09 A 2
In C I have put what I would want it to be. If column B = "A" then I
would want the dates that match to be numbered in sequence , so as the 1's
above they both have a date of 4/06/07 so anything that had that date would
be 1, then the next one that is "A" is 4/03/09 any of those dates that have
a "A" in column B then all the corresponding dates would be number 2, and
so on. Also the adjustments are not in order as mine are above, one A with a
corresponding date may be in several lines throughout the column . I hope I
have explained what I need. Thanks in advance for looking at this for
me. Donna