CountBlank for all Names in a Column, and another trick

Giganews Newsgroups
Subject: CountBlank for all Names in a Column, and another trick
Posted by:  SteveC
Date: Thu, 25 May 2006

                    RankA      RankB
Apples          3                1
Apples
Apples          5                3
Apples          4                2
Apples
Pears
Pears            2                1
Pears          3                2

The Column RankB is counting the number of blank cells for all Apples, and
subracting that number from the column labled RankA.  Any clue as to the
right formula?  Thanks..

Replies