Prev: return 0 if cell has data?
Next: sum column based on single cell match?
From: FSt1 on 9 Apr 2010 20:54
hi
i agree on all points. cave in syndrom is probably why we now have a million
rows and 16000 columns with people trying to use xl as a data base which i
have cautioned against. that is what access is for.

sigh.
regards
FSt1

"JLatham" wrote:

> I think it was a cave-in by the Excel development group to 'demands' made by
> Excel users. Biggest problem (other than the real world headaches it causes
> in worksheet calculation attempts like this or when referenced in macros) is
> that the Help topic doesn't warn against the problems - should have told
> folks to use it sparingly, and ONLY in cells containing labels that would
> never be referenced anywhere else.
>
> Excel Ella: I replied to your other post much the same as Dave Peterson has
> here:
> No worksheet functions that I know of to:
> #1 - even figure out if a cell is a merged cell or not,
> #2 - much less figure out how many cells have been merged together
> #3 - merged cells referenced in calculations/macros = BAD
> Recommendation: go back and take the time to unmerge them and use horizontal
> alignment to "center across selection" so you can use them more easily in
> worksheet formulas and macros.
>
> "FSt1" wrote:
>
> > hi
> > see your post in eggheadcafe.
> >
> > my advice. don't use merged cells. it may "look" good on the sheet but it
> > screws everything else up so i am at a lose as to why MS added this feature
> > in the first place.
> >
> > regards
> > FSt1
> >
> > "Excel Ella" wrote:
> >
> > > Is there a formula I can use to:
> > > 1. Count the number of merged cells (comprised of 3 cells) in a column AND
> > > how many of those are blank?
> > > 2. Count the number of merged cells (comprised of 2 cells) in a column AND
> > > howmany of those are blank?
First  |  Prev  | 
Pages: 1 2
Prev: return 0 if cell has data?
Next: sum column based on single cell match?