count names
On Fri, 5 Feb 2010 04:20:01 -0800, EXCELMACROS
wrote:
hi all…. I’m trying to count the number of times a name is on consecutive
cells. Sounds easy but I can't find a function for this, maybe a little
macro that goes cell by cell on each row? I appreciate your help, for
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.
Try this formula:
=SUMPRODUCT(--((A1:A6)="AAA"),--((A2:A7)<"AAA"))
Hope this helps / Lars-Åke
|