Hi
I tried it and I got #N/A in column C. Am I doing something wrong, Idid the
control shift enter.
Thanks
Donna

"Teethless mama" wrote:

In C2:
=IF(B2="A",SUM(N(FREQUENCY(IF($B$2:B2="A",MATCH($A $2:A2,$A$2:A2,0)),MATCH($A$2:A2,$A$2:A2,0))0)),"" )

ctrl+shift+enter, not just enter
copy down as far as needed


"Donna" wrote:

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