Need help on strange Logic

  • Thread starter Thread starter DracKewl
  • Start date Start date
D

DracKewl

This is what I want to result to look like. I just need
help of the right side of it.

Data:
0, 0, FALSE || >> (GROUP 1) <<This is manual entry
23, 2, TRUE || >> (GROUP 2)
..4, 4, TRUE || >> (GROUP 2)
..3, 1, TRUE || >> (GROUP 2)
..5,-2, FALSE || >> (GROUP 2)
12, 5, || >> (GROUP 3)


What I need to do is look at each row find how many
groupings by using "TRUE" "FALSE".
Here are the rules:
I look to the bottom row and depending on the size of the
two sets of numbers will determin if it's grouped or not
and place a TRUE or FALSE beside it. This is actually
done by a formula, very easy.

The first item starts as "GROUP 1" and every items stays
within that group as long as the item above it doesn't
say FALSE.

How do I get one of the columns to say "GROUP1, Group
2...etc.)?

Thanks in advance!
 
Hi
in your second row enter the formula (I assum it is column D and
TRUE/FALSE are in column C):
="GROUP " & COUNTIF($C$1:$C1)+1
and copy this down
 
Back
Top