|
-
Feb 14th, 2012, 01:56 PM
#6
Frenzied Member
Re: Counting non-blank cells in constantly changing range
the loop man not be necessary!
there are many ways to skin this particular cat!
what are the the preceeding columns a to e?
i ask because you may be able to filter the row in some way to get a range-less answer back...
here to talk
just so you kow its worthwhile talking ...
suggestion 1 ( programming aside ) a new column e is introduced and returns the countif() of the rest of the row.
suggestion 2 ( programming aside ) the rest of the row is a named range - this is because names ranges expand when new columns are inserted - requires that the users insert new columns rather than just put more data in the next available column so its prone to disaster, but is used in some situations!
just the first 2 thoughts
Last edited by incidentals; Feb 14th, 2012 at 02:01 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote