I'm new to these Excel Discussion Boards/Forums as of yesterday, so please
bear with me. I've looked at hundreds of topics and many hundreds of posts,
but haven't found anything that gives me a clue as to how to go about dealing
with this problem:

I have multiple, adjacent columns, in the middle of a sheet, where the
values returned in the cells in these columns are either True or False. I
would like to be able to count up, from the last cell in a (ea.) column
(e.g.- G30:G3) until I reach a value of True, and then return that count
(total number of False or 0 values) into a cell in the same column, several
cells below the last True or False value. I have no need to continue
counting in a given column after that. Each column will have different
locations for the T/F values. Some may show the first value as True, whereas
another may count up 30 or 40 cells with False values before coming to a
True. From what I've read to date, I believe this could be accomplished with
a looping-type formula, using an "x = x - 1" operation to go up one cell at a
time, rather than (having to resort to) a macro, but I'm not sure how to put
it together. Perhaps an If...Then or Do...While/Until situation? or a
Count(If)/Countif? I think I know just enough to be dangerous, but not
enough to figure out even how to start this formula, if in fact, it can be
done with a formula &/or functions. Again, I'm really trying to avoid using
a macro. Any help would be appreciated. Good help would be revered.
--
Sociopath