Results 1 to 2 of 2

Excel 2007 : Count number of blank cells between two words

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    18

    Count number of blank cells between two words

    Hi.. how do I go about counting the number of cells between two words?

    I have multiple words (e.g., DM, DG) arranged in a column and in chronological order (as below). How do I count the number of blank/empty only cells between two words (i.e., between the first DM and DG?

    Also how do I count all cells (with or without text) between DM and DG? Thanks v much.

    11-Nov-10
    29-Oct-10 DM
    30-Sep-10 RL
    31-Aug-10
    31-Jul-10 DG
    30-Jun-10
    31-May-10
    30-Apr-10 DM
    31-Mar-10
    Last edited by northerng; 01-27-2011 at 11:41 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1