count names
hi, (?)
... trying to count the number of times a name is on consecutive cells... example:
A1 = AAA
A2 = AAA
A3 = blank
A4 = AAA
A5 = AAA
A6 = AAA
Then my results should be equal to 2 since the name AAA appear in two groups
first group 2 times and second group 3 times...
(i.e.) =sumproduct(--(a1:a6="aaa"),--(a1:a6<a2:a7))
hthm
hector.
|