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.
Last edited by northerng; 01-27-2011 at 11:41 PM.
Re: Count number of blank cells between two words
this gives number of cells between excluding those cells that contain the text... you can remove the -1 or change to +1 based on whether you want to include one or both cells containing search criteria.
Of course, you can replace the "DG" and "DM" with cell references containing them.
These formulas will look for 1st matches of each text string.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1