Re: Counting Consecutive Cells

Then I am confused where any of these numbers come form

ColA |ColB |ColC |ColD |ColE|ColG
Apples |Off |Coyotes |Apples |Off |2
Bannanas |Apples |Elephants|Bannanas|Off |1
Coyotes |Coyotes |Off |Off |Off |3
Elephants|Elephants|Off |Elephants|Off |4

Whys isn't it 1,1,1,1?


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"SteveC" <SteveC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9CA3C07B-AC85-4429-8B7D-86B4FF612BDC@xxxxxxxxxxxxxxxx
... keeping in mind that the variables that we are matching to Col A are
randomly dispersed or even omitted in Col B, Col C and Col D, and we are
counting consecutively left to right...


.

Relevant Pages

  • Re: help with a formula (New User)
    ... >> differant items but in random order grapes, bannanas, apples, ect. ... >> want to list this weeks price for each fruit. ...
    (microsoft.public.excel.misc)
  • Re: Counting Consecutive Cells
    ... So if Bannanas is only in Col A and Col D, ... Apples Apples Off Apples Off 2 ... Coyotes Coyotes Coyotes Off Off 3 ... Elephants Elephants Elephants Elephants Off 4 ...
    (microsoft.public.excel.misc)
  • Re: Counting Consecutive Cells
    ... Are you saying that Apples should be two because column A contains an Apple, ... Cell G2 looks for the number of consecutive times that anything in range ... Cell G2 is referencing cell A2. ... "Bob Phillips" wrote: ...
    (microsoft.public.excel.misc)
  • Re: IF Then using a column of text and assigning a number to text
    ... thats doesnt seem to work ... "Bob Phillips" wrote: ... etc orange=1, apples =2, etc. ... asssign 1 to oranges 2 to apples, ...
    (microsoft.public.excel.misc)
  • Re: need to go back three lines after a match
    ... Andrew Rich wrote: ... > match on oranges ...
    (comp.lang.perl.misc)