counting valid cells

  • Thread starter Thread starter Kevin J Prince
  • Start date Start date
K

Kevin J Prince

I have a sheet which has varying numbers of data entries depending on
the month.
At the beginning of the data there is the word STARTDATA
after the last data entry it says ENDDATA.
How do I accurately count the number of entries between the two tag
names into a cell showing DATACOUNT= ?


E.g.
abc
def
STARTDATA
1328
21
875
37267
128
3
12
ENDDATA
rst
uvw
DATACOUNT=
 
Assuming the data is in col A,
Try: =MATCH("Enddata",A:A,0)-MATCH("Startdata",A:A,0)-1
 
Max,

Thanks for that it worked a treat, just what I wanted...

Cheers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to get SeriesCollection runtime error 3
data validation for a single text entry 8
Count Cells with alphanumeric data 8
Counting the number of times a character occurs in a cell 1
Count only cells ending with decimal value of .98 4
Countif type thingy... 4
Count number of cells with data validation errors 3
need help on either doing a loop and counting specific values orusing subtotal function 2

Back
Top