count names
Every time your examples change the requirement. If you want a full
solution, give us a full requirement.
Bob
"EXCELMACROS" wrote in message
...
Hi Bob, sorry if i'm not explaining the situation.... your formula does
not
work if we change the scenario, I did,
A1 = Blank
A2 = Blank
A3 = Blank
A4 = AAA
A5 = blank
A6 = AAA
and your formula gives me a 4, i'm expecting a 2. Just to give you more
information, each cell is a day of the month and the name is a person who
will perform a dutie. I want to know at the end of the month how many
times
1 person did two or more days in a row. At the end it could be random so
a
person might perform a function 3 days in a row and I want to count that
as 1
frequency.... make sense?
and I expct
--
Thank you...
"Bob Phillips" wrote:
I didn't allow a for row 1 being blank
=COUNTIF(A1:A6,"<AAA")+(A6="AAA")-(A1<"AAA")
HTH
Bob
"EXCELMACROS" wrote in message
...
Sorry Bob, it does not work. You can try it by changing the places for
example:
A1 = blank
A2 = AAA
A3 = AAA
A4 = AAA
A5 = blank
A6 = AAA
Your formula gives me 3 and i expect 2 (2 groups, group 1 for a2 to a4
and
group 2 for a6)
Thank youf or replying, any other ideas?
--
Thank you...
"Bob Phillips" wrote:
Try
=COUNTIF(A1:A6,"<AAA")+(A6="AAA")
HTH
Bob
"EXCELMACROS" wrote in message
...
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.
--
Thank you...
.
.
|